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

Dave Dumaresq ddumaresq at bccampus.ca
Thu May 5 16:30:48 BST 2011


Thanks for your reply, Nick. I tried your suggestion, and the log does  
show the credentials getting passed in, but it returns the same error.  
(log below).

> isql -v dsn user pass

Dave

cat /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
[ODBC][2347][1304608402.122362][__handles.c][459]
		Exit:[SQL_SUCCESS]
			Environment = 0x8be7f30
[ODBC][2347][1304608402.135885][SQLAllocHandle.c][375]
		Entry:
			Handle Type = 2
			Input Handle = 0x8be7f30
[ODBC][2347][1304608402.136015][SQLAllocHandle.c][493]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x8be8690
[ODBC][2347][1304608402.136190][SQLConnect.c][3654]
		Entry:
			Connection = 0x8be8690
			Server Name = [dsn_myvista][length = 11 (SQL_NTS)]
			User Name = [sa][length = 2 (SQL_NTS)]
			Authentication = [****][length = 4 (SQL_NTS)]
		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][2347][1304608402.304754][SQLConnect.c][4021]
		Exit:[SQL_ERROR]
[ODBC][2347][1304608402.304968][SQLError.c][434]
		Entry:
			Connection = 0x8be8690
			SQLState = 0xbffbe1d2
			Native = 0xbffbdfd4
			Message Text = 0xbffbdfdd
			Buffer Length = 500
			Text Len Ptr = 0xbffbdfda
[ODBC][2347][1304608402.305246][SQLError.c][471]
		Exit:[SQL_SUCCESS]
			SQLState = S1000
			Native = 0xbffbdfd4 -> 0
			Message Text = [[unixODBC][FreeTDS][SQL Server]Unable to connect to  
data source]
[ODBC][2347][1304608402.305443][SQLError.c][434]
		Entry:
			Connection = 0x8be8690
			SQLState = 0xbffbe1d2
			Native = 0xbffbdfd4
			Message Text = 0xbffbdfdd
			Buffer Length = 500
			Text Len Ptr = 0xbffbdfda
[ODBC][2347][1304608402.305537][SQLError.c][471]
		Exit:[SQL_SUCCESS]
			SQLState = 01000
			Native = 0xbffbdfd4 -> 20002
			Message Text = [[unixODBC][FreeTDS][SQL Server]Adaptive Server  
connection failed]
[ODBC][2347][1304608402.305666][SQLError.c][434]
		Entry:
			Connection = 0x8be8690
			SQLState = 0xbffbe1d2
			Native = 0xbffbdfd4
			Message Text = 0xbffbdfdd
			Buffer Length = 500
			Text Len Ptr = 0xbffbdfda
[ODBC][2347][1304608402.305759][SQLError.c][471]
		Exit:[SQL_SUCCESS]
			SQLState = 01000
			Native = 0xbffbdfd4 -> 20017
			Message Text = [[unixODBC][FreeTDS][SQL Server]Unexpected EOF from  
the server]
[ODBC][2347][1304608402.305845][SQLError.c][434]
		Entry:
			Connection = 0x8be8690
			SQLState = 0xbffbe1d2
			Native = 0xbffbdfd4
			Message Text = 0xbffbdfdd
			Buffer Length = 500
			Text Len Ptr = 0xbffbdfda
[ODBC][2347][1304608402.305923][SQLError.c][471]
		Exit:[SQL_NO_DATA]
[ODBC][2347][1304608402.306049][SQLError.c][514]
		Entry:
			Environment = 0x8be7f30
			SQLState = 0xbffbe1d2
			Native = 0xbffbdfd4
			Message Text = 0xbffbdfdd
			Buffer Length = 500
			Text Len Ptr = 0xbffbdfda
[ODBC][2347][1304608402.306134][SQLError.c][551]
		Exit:[SQL_NO_DATA]
[ODBC][2347][1304608402.306331][SQLFreeHandle.c][286]
		Entry:
			Handle Type = 2
			Input Handle = 0x8be8690
[ODBC][2347][1304608402.306428][SQLFreeHandle.c][337]
		Exit:[SQL_SUCCESS]
[ODBC][2347][1304608402.306509][SQLFreeHandle.c][219]
		Entry:
			Handle Type = 1
			Input Handle = 0x8be7f30



On 4-May-11, at 5:37 PM, Nick Gorham wrote:

> On 04/05/2011 20:30, Dave Dumaresq wrote:
>> 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?
>
> I don;t know if the freetds driver reads user and password from the  
> ini file, you could try addingthem when you call isql
>
> isql -v dsn user pass
>
> -- 
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support

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







More information about the unixODBC-support mailing list