FreeTDS Development Group

[Dave Dumaresq <ddumaresq AT bccampus.ca>]

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

I ran this by the folks at unixODBC and they suggested the issue might  
be with freeTDS, since the isql logs show Handle Type = 1, I've  
included the sql dump file below.

I ran osql and found it reports driver line incomplete, but I'm unable  
to figure out what might be the cause. I tried adding Setup=/usr/lib/ 
odbc/libtdsS.so to my odbc.ini (even though it's not recommended in  
the freeTDS configuration documentation), but that didn't make any  
difference.

$ osql -S dsn_myvista -U sa -P 1234
looking for odbc.ini and odbcinst.ini in /usr/local/unixODBC/etc
        reading "/home/ddumaresq/.odbc.ini"
[dsn_myvista] not found in "/home/ddumaresq/.odbc.ini"
        reading "/usr/local/unixODBC/etc/odbc.ini"
[dsn_myvista] found in "/usr/local/unixODBC/etc/odbc.ini"
found this section:
        [dsn_myvista]
        ##Driver=FreeTDS
        Driver=/usr/local/freetds/lib/libtdsodbc.so
        Setup=/usr/lib/odbc/libtdsS.so
        Description=My local vista box containing ACP
        Server=dfd.present.bccampus.ca
        Port=1433
        User=sa
        Password=1234
        Database=ldap
looking for driver for DSN [dsn_myvista]
driver line incomplete for [dsn_myvista] in odbc.ini
looking for driver for DSN [default]
osql: error: no driver found for [dsn_myvista] in odbc.ini

cat /tmp/sql.log
[ODBC][3011][1304616383.932571][__handles.c][459]
                Exit:[SQL_SUCCESS]
                        Environment = 0x8c59f30
[ODBC][3011][1304616383.932848][SQLAllocHandle.c][375]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x8c59f30
[ODBC][3011][1304616383.932995][SQLAllocHandle.c][493]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x8c5a6b0
[ODBC][3011][1304616383.933201][SQLConnect.c][3654]
                Entry:
                        Connection = 0x8c5a6b0
                        Server Name = [dsn_myvista][length = 11 (SQL_NTS)]
                        User Name = [sa][length = 2 (SQL_NTS)]
                        Authentication = [****][length = 4 (SQL_NTS)]
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

                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][3011][1304616383.972882][SQLConnect.c][4021]
                Exit:[SQL_ERROR]
[ODBC][3011][1304616383.973055][SQLError.c][434]
                Entry:
                        Connection = 0x8c5a6b0
                        SQLState = 0xbfb40332
                        Native = 0xbfb40134
                        Message Text = 0xbfb4013d
                        Buffer Length = 500
                        Text Len Ptr = 0xbfb4013a
[ODBC][3011][1304616383.973272][SQLError.c][471]
                Exit:[SQL_SUCCESS]
                        SQLState = S1000
                        Native = 0xbfb40134 -> 0
			Message Text = [[unixODBC][FreeTDS][SQL Server]Unable to connect to  
data source]
[ODBC][3011][1304616383.973441][SQLError.c][434]
                Entry:
                        Connection = 0x8c5a6b0
                        SQLState = 0xbfb40332
                        Native = 0xbfb40134
                        Message Text = 0xbfb4013d
                        Buffer Length = 500
                        Text Len Ptr = 0xbfb4013a
[ODBC][3011][1304616383.973534][SQLError.c][471]
                Exit:[SQL_SUCCESS]
                        SQLState = 01000
                        Native = 0xbfb40134 -> 20002
			Message Text = [[unixODBC][FreeTDS][SQL Server]Adaptive Server  
connection failed]
[ODBC][3011][1304616383.973623][SQLError.c][434]
                Entry:
                        Connection = 0x8c5a6b0
                        SQLState = 0xbfb40332
                        Native = 0xbfb40134
                        Message Text = 0xbfb4013d
                        Buffer Length = 500
                        Text Len Ptr = 0xbfb4013a
[ODBC][3011][1304616383.973708][SQLError.c][471]
                Exit:[SQL_SUCCESS]
                        SQLState = 01000
                        Native = 0xbfb40134 -> 20017
			Message Text = [[unixODBC][FreeTDS][SQL Server]Unexpected EOF from  
the server]
[ODBC][3011][1304616383.973795][SQLError.c][434]
                Entry:
                        Connection = 0x8c5a6b0
                        SQLState = 0xbfb40332
                        Native = 0xbfb40134
                        Message Text = 0xbfb4013d
                        Buffer Length = 500
                        Text Len Ptr = 0xbfb4013a
[ODBC][3011][1304616383.973873][SQLError.c][471]
                Exit:[SQL_NO_DATA]
[ODBC][3011][1304616383.973953][SQLError.c][514]
                Entry:
                        Environment = 0x8c59f30
                        SQLState = 0xbfb40332
                        Native = 0xbfb40134
                        Message Text = 0xbfb4013d
                        Buffer Length = 500
                        Text Len Ptr = 0xbfb4013a
[ODBC][3011][1304616383.974032][SQLError.c][551]
                Exit:[SQL_NO_DATA]
[ODBC][3011][1304616383.974203][SQLFreeHandle.c][286]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x8c5a6b0
[ODBC][3011][1304616383.974288][SQLFreeHandle.c][337]
                Exit:[SQL_SUCCESS]
[ODBC][3011][1304616383.974378][SQLFreeHandle.c][219]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x8c59f30


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