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 peppler dot org>
Subject: RE: Using SYBPERL to query SQLServer
Date: Nov 3 2000 11:06PM

Wechsler, Steven writes:
 > Service pack 2 for SS 7.0 includes the fixes for DBLibrary.  And the latest
 > version of Sybperl works without any service packs.  I'm sure Michael will
 > be around shortly to follow up...

I actually replied to this thread earlier today... This is really an
issue of whether the Sybase libraries can be used to access MS-SQL. As 
of service pack 2 of SS7 both DBlibrary and Client Library work (with
some limitations, because of falling back to the 4.2 protocol level.)

The FreeTDS project ( re-implements the DBlibrary and
Client Library APIs and attempt to cover TDS 7 which is what SS7 uses
by default. By using the FreeTDS libs you can use sybperl (or
DBD::Sybase) to access MS-SQL with the TDS 7 protocol.

Note however that FreeTDS is not *complete*, and there are probably


 > > -----Original Message-----
 > > From: Jeff Greif []
 > > Sent: Friday, November 03, 2000 5:24 PM
 > > To: SybPerl Discussion List
 > > Subject: Re: Using SYBPERL to query SQLServer
 > > 
 > > 
 > > On the archives of this list, you can find discussions of 
 > > support in MS SQL
 > > Server for Sybase::Dblib and Sybase::CTlib.  The situation is 
 > > that it worked
 > > in SS6.x, but broke in early releases of SS7.0 because 
 > > Microsoft made some
 > > changes to the protocol.  After some people complained, MS 
 > > developed a patch
 > > which was given out to people who could grouse loudly enough 
 > > and pay for
 > > support.  The patch *may* have made it into the SS7 service packs.  I
 > > suppose this indicates that Microsoft is not completely 
 > > opposed to staying
 > > compatible in future, without committing to anything though.  We use
 > > Sybase::CTlib quite successfully.
 > > 
 > > Jeff
 > > 

Michael Peppler - Data Migrations Inc. - - - AIM MPpplr
International Sybase User Group -
Sybase on Linux mailing list: