FreeTDS Development Group

[Stefan Radman <Stefan.Radman AT CTBTO.ORG>]

Try this ODBC.INI:

 

[NSSQL]

Description     = NS-DeptSQL

Driver          = TDS

Trace           = Yes

TraceFile       = /tmp/odbc.trace

Database        = NSDEPT-Access

Server          = 10.49.25.24

Port            = 1433

TDS_Version = 8.0

 

And forget about freetds.conf.

 

More info is at

http://www.freetds.org/userguide/odbcinionly.htm

http://www.freetds.org/userguide/odbcconnattr.htm#TAB.CONNECTION.ATTRIBU
TES

 

Stefan

 

From: unixodbc-support-bounces AT mailman.unixodbc.org
[mailto:unixodbc-support-bounces AT mailman.unixodbc.org] On Behalf Of
O'Neil, Donald A.
Sent: Monday, 03 November, 2008 22:10
To: unixodbc-support AT mailman.unixodbc.org; freetds AT lists.ibiblio.org
Subject: [unixODBC-support] [S1000][unixODBC][FreeTDS][SQL Server]Unable
toconnect to data source

 

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