Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

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 []
> Sent: Monday, March 09, 1998 7:23 AM
> To:
> 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
> or
> > 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
> --
> Michael Peppler         -||-  Data Migrations Inc.
>    -||-
> Int. Sybase User Group  -||-

Michael Peppler         -||-  Data Migrations Inc.    -||-
Int. Sybase User Group  -||-