Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: Microsfot SQL 7 and Sybperl
Date: Mar 9 1998 6:00PM
Tim Holt wrote:
> I hate to think about moving away from using the Sybperl package. It's
> never ever let us down. But, does anyone have a suggested path to use
> one API for Sybase and MS-SQL, where they "talk" differently? Are we
> talking DBD/DBI here?
Erland Sommarskog has built a version of sybperl that uses the MS
libraries which has the same api (I think) as sybperl (but that runs
on NT - don't know what platform you're on).
Otherwise, to access MS-SQL server from Unix you need to go to ODBC,
which means DBI & DBD::ODBC for perl access. That should work fine,
and you could use DBD::Sybase for the Sybase side. Now I don;t
know how well ODBC supports things like stored procs returning
rows and output params (which I suspect MSSQL still allows) as
I had to do some special processing in DBD::Sybase to allow that, as
well as multiple result set processing per SQL request.
> -----Original Message-----
> From: Michael Peppler [mailto:firstname.lastname@example.org]
> Sent: Monday, March 09, 1998 7:23 AM
> To: SYBPERL-L@trln.lib.unc.edu
> Subject: Re: Microsfot SQL 7 and Sybperl
> Henrik Edlund wrote:
> > There are rumors that the next version of MS-SQL (version 7) will have
> > changed protocol. It will no longer work with the Sybase protocol.
> > Anyone know if this is true and if it's true, will Sybperl support it
> > will Sybperl stay Sybase-only?
> Sybperl links against the Sybase libraries, so by definition it
> will only support the Sybase protocol, and any common backwards
> compatible subset of the MS version of TDS.
> Changing the protocol in MS-SQL 7.x would be a typical MS thing
> to do - you'd need to use the MS tools & libs to use the thing.
> I don't remember if the agreement between Sybase and MS states
> that the servers *must* understand a common subset of the protocol
> (currently the subset is the version of TDS that was used with
> MS/Sybase 4.2).
> Michael Peppler -||- Data Migrations Inc.
> email@example.com -||- http://www.mbay.net/~mpeppler
> Int. Sybase User Group -||- http://www.isug.com
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com