freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

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?

Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005, Michael Gurfinkel [TSS], 09/06/2011
- Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005, James K. Lowden, 09/06/2011
  - Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005, Michael Gurfinkel [TSS], 09/07/2011
    - Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005, Ken Collins, 09/07/2011
      - Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005, Michael Gurfinkel [TSS], 09/07/2011
        
        [freetds] ignore --tdsver, Mike Slifcak, 09/07/2011
        
        Re: [freetds] ignore --tdsver, Ken Collins, 09/07/2011
        
        Re: [freetds] ignore --tdsver, Craig A. Berry, 09/07/2011
        
        Message not available
        Re: [freetds] ignore --tdsver, Craig A. Berry, 09/08/2011
        Re: [freetds] ignore --tdsver, James K. Lowden, 09/08/2011
        Re: [freetds] ignore --tdsver, Bob Hetzel, 09/09/2011
        Re: [freetds] ignore --tdsver, jklowden, 09/09/2011
        
        [freetds] auto login protocol retry (was Re: ignore --tdsver), Mike Slifcak, 09/14/2011
        Re: [freetds] auto login protocol retry (was Re: ignore --tdsver), James K. Lowden, 09/15/2011
        
        Re: [freetds] ignore --tdsver, Craig A. Berry, 09/09/2011