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: Ken Collins <ken AT metaskills.net>
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 17:29:52 -0400

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

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