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: TDS 42
Date: Apr 30 2002 2:58PM

On Tue, 2002-04-30 at 01:37, Henson, David A wrote:
> 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?

No, that doesn't work (or at least didn't work with MS-SQL 7) I have not
tried this with MS-SQL 2000.

You can try this however:

$dbh = new Sybase::CTlib user, pwd, server, appname,   
                        {CON_PROPS=>{CS_TDS_VERSION => CS_TDS_42}};

Maybe that'll work (it should set the TDS_VERSION to CS_TDS_42 before
attempting the connect.


> -----Original Message-----
> From: Michael Peppler []
> 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.
>           *or*
> International Sybase User Group:
Michael Peppler                              Data Migrations, Inc.           *or*
International Sybase User Group: