FreeTDS Development Group

["Lisa Ryan" <ryanl AT bigpicture.ie>]

version 7 is for MSSQL 7 and version 8 is for MSSQL 2000.
I had the same problem as freetds was defaulting to version 5 which won't
speak to MSSQL 7, but I configured it with version 7 and also preplaced 4.2
in the freetds.conf file and it worked.


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of Lowden, James K
Sent: Thursday, March 13, 2003 8:06 PM
To: 'FreeTDS Development Group'
Subject: RE: [freetds] tsql problem


> 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.


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

**NOTE**
Privileged/Confidential Information may be contained in this message.

If you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
message to anyone.
In such case, you should destroy this message and kindly notify the sender
by reply email. Please advise  immediately if you or your employer does not
consent to Internet email for messages of this kind.  Opinions,  conclusions
and other information in this message that do not relate to the official
business of my firm shall be understood as neither given nor endorsed by it.


This E-mail and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they   
are addressed. If you have received this E-mail in error please notify us 
immediately and delete this E-mail from your system. Thank you.
It is possible for data transmitted by email to be deliberately or
accidentally corrupted or intercepted. For this reason, where the
communication is by E-mail, the Big Picture Group does not accept 
any responsibility for any breach of confidence which may arise through the 
use of this medium.
Opinions, conclusions and other information in this message that do not 
relate to the official business of Big Picture Group shall be understood as 
neither given nor endorsed by it.
This footnote also confirms that this email message has been swept for the 
presence of known computer viruses.