[freetds] Cannot connect to SQL6.5 with tsql

Daniel Morgan danmorg at sc.rr.com
Thu Dec 19 14:57:36 EST 2002


I'm only guessing here...

Try setting the TDS Version to 4.2

You can do this many ways:
- rebuilding freetds to use tds version 4.2
  for example:
  $ ./configure --with-tdsver=7.0 --prefix=/opt/freetds

- in freetds.conf, set tds version to equal 4.2
  for example:
  [sqlserver65]
     host = ntbox.mydomain.com
     port = 1433
     tds version = 4.2

- set environment variable TDSVER to equal 42

  for example in a bash shell:
  $ export TDSVER=4.2

  for example in a csh shell:
  $ setenv TDSVER 4.2

For more information, read the FreeTDS User Guide at:
http://www.freetds.org/userguide/

-----Original Message-----
From: freetds-admin at lists.ibiblio.org
[mailto:freetds-admin at lists.ibiblio.org]On Behalf Of Eric Augustus
Sent: Thursday, December 19, 2002 2:11 PM
To: FreeTDS mailing list
Subject: [freetds] Cannot connect to SQL6.5 with tsql


While testing the CVS snapshot from 12/16/02 on several of my test MSSQL
servers, I came across a login problem with MSSQL 6.5. I cannot get tsql
to login to my test SQL 6.5 server. It works fine against my SQL7 and
SQL2k servers; both with sa[no password] accounts.

Here's the command line used:

$> tsql -H 10.89.144.208 -p 1433 -U sa -P ""
locale is "C"
using default charset "iso_1"
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

I've tested this server against the 0.60 release without any problems.

Attached is the freetds.conf I used, which is the default.
Also, I've attached a tdsdump log file.

BTW, freetds was built using the following configure command:
$> ./configure --with-tdsver=7.0 --prefix=/opt/freetds

Any ideas?

-- 
----------------------------------------------------------
   Eric P. Augustus            | gaugustu at cisco.com       
   Network Security Engineer   | www.cisco.com
   Cisco Systems Inc.          | Voice: 512.378.1051
   12515 Research Blvd.        | Fax: 512.378.1425
   Austin, Texas  78759-2220   | Pager: 800.365.4578
----------------------------------------------------------
It's not enough to be Hungarian; you must have talent too.
		-- Alexander Korda




More information about the FreeTDS mailing list