Skip to Content.
Sympa Menu

freetds - [freetds] [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "O'Neil, Donald A." <DONALD.A.O'NEIL AT saic.com>
  • To: <unixodbc-support AT mailman.unixodbc.org>, <freetds AT lists.ibiblio.org>
  • Subject: [freetds] [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
  • Date: Mon, 3 Nov 2008 13:09:37 -0800

I am having a problem getting unixODBC/FreeTDS to work.. I am getting
the error:



[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source.



Based on all the messages I've reviewed that google came up with, I
believe I have everything configured correctly, but I may have missed
something.



Here's the contents of my config files:



Odbc.ini:



[NSSQL]

Description = NS-DeptSQL

Driver = TDS

Trace = Yes

TraceFile = /tmp/odbc.trace

Database = NSDEPT-Access

Server = NSSQL

Port = 1433



Odbvcinst.ini:



[TDS]

Description = FreeTDS Driver for Linux & MSSQL

Driver = /usr/local/freetds/lib/libtdsodbc.so

Setup = /usr/local/freetds/lib/libtdsS.so

FileUsage = 1


CPTimeout =

CPReuse =

UsageCount = 1



[ODBC]

Trace = Yes

TraceFile = /tmp/odbcinst_tr

ForceTrace = Yes



Freetds.conf:



[NSSQL]

host = 10.49.25.24

port = 1433

tds version = 8.0



The trace file shows this:



[ODBC][21313][__handles.c][444]

Exit:[SQL_SUCCESS]

Environment = 0x8050388

[ODBC][21313][SQLAllocHandle.c][346]

Entry:

Handle Type = 2

Input Handle = 0x8050388

[ODBC][21313][SQLAllocHandle.c][464]

Exit:[SQL_SUCCESS]

Output Handle = 0x8050918

[ODBC][21313][SQLConnect.c][3550]

Entry:

Connection = 0x8050918

Server Name = [NSSQL][length = 5 (SQL_NTS)]

User Name = [NOCReader][length = 9 (SQL_NTS)]

Authentication = [*********][length = 9
(SQL_NTS)]

UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
'UCS-2LE'



DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to
data source



[ODBC][21313][SQLConnect.c][3918]

Exit:[SQL_ERROR]

[ODBC][21313][SQLError.c][424]

Entry:

Connection = 0x8050918

SQLState = 0xbfbc5e4a

Native = 0xbfbc5e54

Message Text = 0xbfbc5c55

Buffer Length = 500

Text Len Ptr = 0xbfbc5e5a

[ODBC][21313][SQLError.c][461]

Exit:[SQL_SUCCESS]

SQLState = S1000

Native = 0xbfbc5e54 -> 0

Message Text = [[unixODBC][FreeTDS][SQL
Server]Unable to connect to data source]

[ODBC][21313][SQLError.c][424]

Entry:

Connection = 0x8050918

SQLState = 0xbfbc5e4a

Native = 0xbfbc5e54

Message Text = 0xbfbc5c55

Buffer Length = 500

Text Len Ptr = 0xbfbc5e5a

[ODBC][21313][SQLError.c][461]

Exit:[SQL_NO_DATA]D



When I execute this:



isql -v NSSQL USER PASSWORD



Any ideas as to what's going on here?



________________________________

Don O'Neil
Senior Network Engineer
SAIC - CCSD Network Operations
(702) 351-7261 cell

(702) 799-6174 fax

0099-5941 wan

oneilda AT saic.com







Archive powered by MHonArc 2.6.24.

Top of Page