FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Craig A. Berry [mailto:craigberry AT mac.com]
> Sent: March 13, 2003 12:56 PM
> 
> At 1:34 PM -0800 3/12/03, Rusty Wright wrote:
> 
> >When I compiled freetds I used the following configure options:
> >
> >                --with-tdsver=4.2
> 
> MS SQL 2000 does not speak TDS 5.0 and I don't know if it will do 4.2
> either.  Try 8.0 and/or 7.0 and see if you fare any better.  You may
> also want to define the environment variable TDSDUMPCONFIG to see a
> bit more about what's going amiss in the login conversation.

I haven't been able to reproduce Rusty's problem.  2000 speaks 4.2:

$ tsql -S nts0090 -UJimLowden
locale is "C"
using default charset "iso_1"
1> version
using TDS version 4.2
1> select @@version
2> go

Microsoft SQL Server  2000 - 8.00.679 (Intel X86)
        Aug 26 2002 15:09:48
        Copyright (c) 1988-2000 Microsoft Corporation
        Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

1> quit

It may have to do with "try domain login" in freetds.conf.  That should be
"no" in his case.  

> It would be nice to get an update to docs/getting_started.txt about
> what server products support what TDS versions by one of the gurus
> out there who has that matrix in his or her head.

Hmm.  Thanks for mentioning it, Craig.  Reading that file, I think "rm
getting_started.txt" is the best answer.  It's out of date, wrong,
incomplete.  I'm sure I'm leaving something out.  ;-)

The matrix you seek is in the UG http://www.freetds.org/userguide/x574.htm.
I mean that to be comprehensive and accurate.  I see it's not: it implies
but doesn't state that 4.2 is available on all servers (except ASA).  I
think I'll add a column to Table 3-1 indicating alternatives.  

If you mean something else, please say.  

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.