[unixODBC-support] [unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server

Dave Dumaresq ddumaresq at bccampus.ca
Wed May 4 20:30:35 BST 2011


Greetings, I have freeTDS and unixODBC installed on Ubuntu 10.10, and  
I'm connecting to an SQL Server 2005 host on port 1433 running on a  
vista box.

tsql works fine; however, isql fails with a final error message  
'Unexpected EOF from the server'

$ sudo isql -v dsn_myvista
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
[01000][unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
[ISQL]ERROR: Could not SQLConnect

The logs (below) seem to show that during the connection to  
[dsn_myvista] the User Name and Authentication are NULL.
Any suggests about what might be wrong?

/etc/odbc.ini
[dsn_myvista]
Driver=FreeTDS
Server=my.server.org
Port=1433
User=sa
Password=***
Database=ldap

/etc/odbcinst.ini
[FreeTDS]
Driver=/usr/local/freetds/lib/libtdsodbc.so

[ODBC]
Trace        = Yes
TraceFile    = /tmp/sql.log
ForceTrace   = Yes

$ more /tmp/sql.log
[ODBC][1998][1304536761.718727][__handles.c][459]
		Exit:[SQL_SUCCESS]
			Environment = 0x945ef30
[ODBC][1998][1304536761.719232][SQLAllocHandle.c][375]
		Entry:
			Handle Type = 2
			Input Handle = 0x945ef30
[ODBC][1998][1304536761.719387][SQLAllocHandle.c][493]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x945f690
[ODBC][1998][1304536761.719573][SQLConnect.c][3654]
		Entry:
			Connection = 0x945f690
			Server Name = [dsn_myvista][length = 11 (SQL_NTS)]
			User Name = [NULL]
			Authentication = [NULL]
		DIAG [01000] [FreeTDS][SQL Server]Unexpected EOF from the server

		DIAG [01000] [FreeTDS][SQL Server]Adaptive Server connection failed

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

[ODBC][1998][1304536761.761946][SQLConnect.c][4021]
		Exit:[SQL_ERROR]
[ODBC][1998][1304536761.762111][SQLError.c][434]
		Entry:
			Connection = 0x945f690
			SQLState = 0xbfedc322
			Native = 0xbfedc124
			Message Text = 0xbfedc12d
			Buffer Length = 500
			Text Len Ptr = 0xbfedc12a
[ODBC][1998][1304536761.762319][SQLError.c][471]
		Exit:[SQL_SUCCESS]
			SQLState = S1000
			Native = 0xbfedc124 -> 0
			Message Text = [[unixODBC][FreeTDS][SQL Server]Unable to connect to  
data source]
[ODBC][1998][1304536761.762513][SQLError.c][434]
		Entry:
			Connection = 0x945f690
			SQLState = 0xbfedc322
			Native = 0xbfedc124
			Message Text = 0xbfedc12d
			Buffer Length = 500
			Text Len Ptr = 0xbfedc12a
[ODBC][1998][1304536761.762609][SQLError.c][471]
		Exit:[SQL_SUCCESS]
			SQLState = 01000
			Native = 0xbfedc124 -> 20002
			Message Text = [[unixODBC][FreeTDS][SQL Server]Adaptive Server  
connection failed]
[ODBC][1998][1304536761.762692][SQLError.c][434]
		Entry:
			Connection = 0x945f690
			SQLState = 0xbfedc322
			Native = 0xbfedc124
			Message Text = 0xbfedc12d
			Buffer Length = 500
			Text Len Ptr = 0xbfedc12a
[ODBC][1998][1304536761.762841][SQLError.c][471]
		Exit:[SQL_SUCCESS]
			SQLState = 01000
			Native = 0xbfedc124 -> 20017
			Message Text = [[unixODBC][FreeTDS][SQL Server]Unexpected EOF from  
the server]
[ODBC][1998][1304536761.763083][SQLError.c][434]
		Entry:
			Connection = 0x945f690
			SQLState = 0xbfedc322
			Native = 0xbfedc124
			Message Text = 0xbfedc12d
			Buffer Length = 500
			Text Len Ptr = 0xbfedc12a
[ODBC][1998][1304536761.763159][SQLError.c][471]
		Exit:[SQL_NO_DATA]
[ODBC][1998][1304536761.763276][SQLError.c][514]
		Entry:
			Environment = 0x945ef30
			SQLState = 0xbfedc322
			Native = 0xbfedc124
			Message Text = 0xbfedc12d
			Buffer Length = 500
			Text Len Ptr = 0xbfedc12a
[ODBC][1998][1304536761.763357][SQLError.c][551]
		Exit:[SQL_NO_DATA]
[ODBC][1998][1304536761.763711][SQLFreeHandle.c][286]
		Entry:
			Handle Type = 2
			Input Handle = 0x945f690
[ODBC][1998][1304536761.763818][SQLFreeHandle.c][337]
		Exit:[SQL_SUCCESS]
[ODBC][1998][1304536761.763895][SQLFreeHandle.c][219]
		Entry:
			Handle Type = 1
			Input Handle = 0x945ef30


--
Dave Dumaresq
Technical Analyst - BCcampus
200 - 555 Seymour St, Vancouver BC
Phone: 604-412-7738







More information about the unixODBC-support mailing list