|
|
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 (www.freetds.org) 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
bugs!
Michael
> > -----Original Message-----
> > From: Jeff Greif [mailto:jgreif@befree.com]
> > 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. - mpeppler@peppler.org
http://www.mbay.net/~mpeppler - mpeppler@mbay.net - AIM MPpplr
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com
|
