Re: [unixODBC-support] [S1000][unixODBC][FreeTDS][SQL Server]Unable toconnect to data source
Stefan Radman <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <20081104.072832.628317.ED7D92ECCF5A8E5EE92BA752FB5E7744@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: [email protected] [mailto:[email protected]] On Behalf Of O'Neil, Donald A. Sent: Monday, 03 November, 2008 22:10 To: [email protected]; [email protected] 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 [email protected]