Re: Only TDSVER=4.2 works when connecting to MS SQL 2005

 

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Ken Collins
Sent: Wednesday, September 07, 2011 2:30 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005

On Sep 7, 2011, at 5:08 PM, Michael Gurfinkel [TSS] wrote:

> util.c:331:tdserror(0x804f020, 0x804f960, 100, 0) 
> dblib.c:7929:dbperror(0x804f1a0, 100, 0)
> dblib.c:7981:100: "TDS version downgraded to 7.1!"
> dblib.c:5780:dbgetuserdata(0x804f1a0)
> dblib.c:4880:dbdead(0x804f1a0) [dead]
> 
> I took err_handler from example and patched it to say that if(dberr == 
> 100) to behave as anticipated error and I am able to select / update /
insert.
> Would you please let me know if I should try to dig further and see 
> why 7.2 is not happy with my 2005 db? Please clarify.

> I was just talking about that last week. Maybe this thread will be
helpful.

> http://lists.ibiblio.org/pipermail/freetds/2011q3/027306.html

>  - Ken

Thanks

I'd like to verify one more bit of my setup
When I run 
$ tsql -C |grep version:
                        TDS version: 5.0

Is TDS version 5.0 good? 
Do I need to re-build TDS specifying --with-tdsver=7.2?

Although 
$ configure --help|grep --with-tdsver 
 --with-tdsver=VERSION   TDS protocol version (4.2/4.6/5.0/7.0/7.1) [5.0]
Somehow 7.2 is missing here - does it mean my build is not good?