|
|
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.
Michael
> -----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
>
--
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
|
