sybperl-l Archive

From: "Henson, David A" <david dot a dot henson at citigroup dot com>
Subject: RE: TDS 42
Date: Apr 30 2002 8:37AM

Thanks Michael,

I thought it might be possible as even in Open Client 12.5 Sybase imply that
you can specify a value (include 4.2) by setting the cs_tds_version in the
connection properties. I thought there might be a sybperl parameter to force
this?

http://manuals.sybase.com:80/onlinebooks/group-cn/cng1250e/ctref/@ebt-link;n
h=1;pt=5473?target=%25N%15_17194_START_RESTART_N%25;__prev_hit__=5473;__next
_hit__=17198;DwebQuery=Cs_TDS_VERSION&DwebSearchAll=1

Thanks again
David



-----Original Message-----
From: Michael Peppler [mailto:mpeppler@peppler.org]
Sent: 29 April 2002 22:34
To: SybPerl Discussion List
Subject: Re: TDS 42


On Mon, 2002-04-29 at 06:10, Henson, David A wrote:
> 
> I was just trying to find out if it is possible to set the TDS version
> within a sybperl script?

Yes, it is possible.

However, this won't help you to connect to an MSSQL server.

For MS-SQL 6.5, Sybase's libraries will work fine.
For 7.0 you will need one of the later service packs (I'm not sure which
one, possibly sp2).
For 2k the Sybase libs will not work - your only choice there is to use
FreeTDS - because MS go out of their way to break the protocol,
unfortunately.

(it is *possible* that Sybase::DBlib will still work with the Sybase
libs and recent versions of MS-SQL - try building it with the -DMSSQL
option turned on)

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org           *or*          mpeppler@mbay.net
http://www.mbay.net/~mpeppler
International Sybase User Group: http://www.isug.com