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: Tue, 6 Sep 2011 13:46:29 -0700

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Monday, August 22, 2011 8:02 PM
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] Only TDSVER=4.2 works when connecting to MS SQL 2005

On Mon, 22 Aug 2011 14:50:36 -0700
"Michael Gurfinkel [TSS]" <michael AT tsswireless.com> wrote:

> My setup is :
> MS SQL 2005 running under Win 2003,
> Latest 0.91 version of FreeTDS under Unix (SCO)
> I build it with ./configure --enable-msdblib --with-tdsver=7.2
> I use $HOME/.freetds.conf to configure connection
>
> I can connect to the db only when my tds version is set to 4.2, when I
> tried 7, 7.1, 7.2, 8 it fails to connect.
>
> My question - would it be limiting factor?

Yes. You want to figure out what's wrong.

> 14:36:28.595890 3933 (login.c:1057):detected flag 2
> 14:36:28.595903 3933 (login.c:782):quietly sending TDS 7+ login packet
...
> 14:36:28.596526 3933 (dblib.c:7929):dbperror(804f988, 20017, 0)
> 14:36:28.596541 3933 (dblib.c:7981):20017: "Unexpected EOF from the
> server"

The server is rejecting your login, but not for a bad username/password
(else you'd see a message). Is there some sort of encryption or Kerberos
login being used, or supposed to be? Whenever we've seen this before, it's
seems it's always been something like that.

--jkl

Sorry for a long interruption - I was pulled from the project, but now I am
back.

I am not aware of any encryption or Kerberos login, but I don't know how to
validate it. All I know this is 2005 SQL Server with authentication set to
mixed (Windows and SQL Server) mode.

I still don't know why do I need to find out the reason for TDS 7+ login to
fail. What would be my limitations if I will use 4.2?
Thank you.

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

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