[freetds] MS SQL Server access works with tsql but not with isql
Brad McNeely
brad_mcneely at excite.com
Mon Dec 13 19:33:04 EST 2004
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!
More information about the FreeTDS
mailing list