Skip to Content.
Sympa Menu

freetds - RE: [freetds] Cannot connect to SQL6.5 with tsql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Daniel Morgan" <danmorg AT sc.rr.com>
  • To: <freetds AT lists.ibiblio.org>
  • Cc: "Eric Augustus" <gaugustu AT cisco.com>
  • Subject: RE: [freetds] Cannot connect to SQL6.5 with tsql
  • Date: Thu, 19 Dec 2002 14:57:36 -0500

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





Archive powered by MHonArc 2.6.24.

Top of Page