|
|
Choosing A Webhost: |
MS SQL Server access works with tsql but not with isql: msg#00223db.tds.freetds
Using the rpms freetds-0.62.1-1.i586.rpm freetds-unixodbc-0.62.1-1.i586.rpm from the freetds web site I'm up and running. I'm able to connect to an MSSQL Server database using tsql but not isql. Here are my files: /etc/unixODBC/odbcinst.ini [TDS] Description = TDS Test Driver = /usr/lib/libtdsodbc.so Setup = /usr/lib/unixODBC/libtdsS.so.1 FileUsage = 1 /etc/unixODBC/odbc.ini [mssql] Description = TDS Driver = TDS Servername = 192.168.1.101 Database = pubs UID = bmcneely PWD = Port = 1433 /etc/freetds.conf [TDS] host = 192.168.1.101 port = 1433 tds version = 7.0 Here's the error: isql -v mssql bmcneely [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source [ISQL]ERROR: Could not SQLConnect and here's the sql.log from the ODBC trace: [ODBC][8246][__handles.c][421] Exit:[SQL_SUCCESS] Environment = 0x8052488 [ODBC][8246][SQLAllocHandle.c][345] Entry: Handle Type = 2 Input Handle = 0x8052488 [ODBC][8246][SQLAllocHandle.c][463] Exit:[SQL_SUCCESS] Output Handle = 0x8052c08 [ODBC][8246][SQLConnect.c][3452] Entry: Connection = 0x8052c08 Server Name = [mssql][length = 5 (SQL_NTS)] User Name = [][length = 0 (SQL_NTS)] Authentication = [][length = 0 (SQL_NTS)] UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE' DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data source [ODBC][8246][SQLConnect.c][3820] Exit:[SQL_ERROR] [ODBC][8246][SQLError.c][424] Entry: Connection = 0x8052c08 SQLState = 0xbfffebe0 Native = 0xbfffebd8 Message Text = 0xbfffebf0 Buffer Length = 500 Text Len Ptr = 0xbfffebde [ODBC][8246][SQLError.c][461] Exit:[SQL_SUCCESS] SQLState = S1000 Native = 0xbfffebd8 -> 0 Message Text = [[unixODBC][FreeTDS][SQL Server]Unable to connect to data source] [ODBC][8246][SQLError.c][424] Entry: Connection = 0x8052c08 SQLState = 0xbfffebe0 Native = 0xbfffebd8 Message Text = 0xbfffebf0 Buffer Length = 500 Text Len Ptr = 0xbfffebde [ODBC][8246][SQLError.c][461] Exit:[SQL_NO_DATA] [ODBC][8246][SQLError.c][504] Entry: Environment = 0x8052488 SQLState = 0xbfffebe0 Native = 0xbfffebd8 Message Text = 0xbfffebf0 Buffer Length = 500 Text Len Ptr = 0xbfffebde [ODBC][8246][SQLError.c][541] Exit:[SQL_NO_DATA] [ODBC][8246][SQLFreeHandle.c][268] Entry: Handle Type = 2 Input Handle = 0x8052c08 [ODBC][8246][SQLFreeHandle.c][317] Exit:[SQL_SUCCESS] [ODBC][8246][SQLFreeHandle.c][203] Entry: Handle Type = 1 Input Handle = 0x8052488 [ODBC][8500][__handles.c][421] Exit:[SQL_SUCCESS] Environment = 0x8052488 [ODBC][8500][SQLAllocHandle.c][345] Entry: Handle Type = 2 Input Handle = 0x8052488 [ODBC][8500][SQLAllocHandle.c][463] Exit:[SQL_SUCCESS] Output Handle = 0x8052c08 [ODBC][8500][SQLConnect.c][3452] Entry: Connection = 0x8052c08 Server Name = [mssql][length = 5 (SQL_NTS)] User Name = [bmcneely][length = 8 (SQL_NTS)] Authentication = [][length = 0 (SQL_NTS)] UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE' DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data source [ODBC][8500][SQLConnect.c][3820] Exit:[SQL_ERROR] [ODBC][8500][SQLError.c][424] Entry: Connection = 0x8052c08 SQLState = 0xbfffebd0 Native = 0xbfffebc8 Message Text = 0xbfffebe0 Buffer Length = 500 Text Len Ptr = 0xbfffebce [ODBC][8500][SQLError.c][461] Exit:[SQL_SUCCESS] SQLState = S1000 Native = 0xbfffebc8 -> 0 Message Text = [[unixODBC][FreeTDS][SQL Server]Unable to connect to data source] [ODBC][8500][SQLError.c][424] Entry: Connection = 0x8052c08 SQLState = 0xbfffebd0 Native = 0xbfffebc8 Message Text = 0xbfffebe0 Buffer Length = 500 Text Len Ptr = 0xbfffebce [ODBC][8500][SQLError.c][461] Exit:[SQL_NO_DATA] [ODBC][8500][SQLError.c][504] Entry: Environment = 0x8052488 SQLState = 0xbfffebd0 Native = 0xbfffebc8 Message Text = 0xbfffebe0 Buffer Length = 500 Text Len Ptr = 0xbfffebce [ODBC][8500][SQLError.c][541] Exit:[SQL_NO_DATA] [ODBC][8500][SQLFreeHandle.c][268] Entry: Handle Type = 2 Input Handle = 0x8052c08 [ODBC][8500][SQLFreeHandle.c][317] Exit:[SQL_SUCCESS] [ODBC][8500][SQLFreeHandle.c][203] Entry: Handle Type = 1 Input Handle = 0x8052488 Any help is greatly appreciated. Regards, Brad McNeely _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web!
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Compile fails, Brad McNeely |
|---|---|
| Next by Date: | Re: Connection Pool crashing problems?, Brian Bruns |
| Previous by Thread: | Compile fails, Brad McNeely |
| Next by Thread: | Re: MS SQL Server access works with tsql but not with isql, Brian Bruns |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |