Skip to Content.
Sympa Menu

freetds - Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Michael Gurfinkel [TSS]" <michael AT tsswireless.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005
  • Date: Wed, 7 Sep 2011 15:51:57 -0700



-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] 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.

> https://lists.ibiblio.org/sympa/arc/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?





Archive powered by MHonArc 2.6.24.

Top of Page