[freetds] unixODBC failing to connect.

Jeff Honey jhoney at psmanagement.net
Tue Apr 15 10:06:55 EDT 2003


FreeTDS .61 (stable)
unixODBC 2.2.5

I have had a tremendously difficult time in getting what at first appeared
to be a relatively simple thing to work. Everything compiled and installed
flawlessly but after a number of earnest attempts, I am still without ODBC
to my MSSQL server from my linux box. tsql testing seems to bear out that
FreeTDS works connecting directly to the server, though. Below are snippets
of configuration files and error msgs. Any help would be appreciated. If I
am being redundantly redundant and my answers are already answered
elsewhere, my apologies.





contents of SQL trace:
[ODBC][23568][__handles.c][399]
                Exit:[SQL_SUCCESS]
                        Environment = 0x804e920
[ODBC][23568][SQLAllocHandle.c][338]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x804e920
[ODBC][23568][SQLAllocHandle.c][462]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x804f018
[ODBC][23568][SQLConnect.c][3184]
                Entry:            
                        Connection = 0x804f018            
                        Server Name = [testserver][length = 10 (SQL_NTS)]

                        User Name = [sa][length = 2 (SQL_NTS)]            
                        Authentication = [][length = 0 (SQL_NTS)]
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
'UCS-2LE'

                DIAG [S1000] Client unable to establish connection

[ODBC][23568][SQLConnect.c][3569]
                Exit:[SQL_ERROR]
[ODBC][23568][SQLError.c][401]
                Entry:                
                        Connection = 0x804f018                
                        SQLState = 0xbffff4b0                
                        Native = 0xbffff4a8                
                        Message Text = 0xbffff4c0                
                        Buffer Length = 500                
                        Text Len Ptr = 0xbffff4ae
[ODBC][23568][SQLError.c][438]
                Exit:[SQL_SUCCESS]                    
                        SQLState = S1000                    
                        Native = 0xbffff4a8 -> 1                    
                        Message Text = [[unixODBC]Client unable to establish
connection]
[ODBC][23568][SQLError.c][401]
                Entry:                
                        Connection = 0x804f018                
                        SQLState = 0xbffff4b0                
                        Native = 0xbffff4a8                
                        Message Text = 0xbffff4c0                
                        Buffer Length = 500                
                        Text Len Ptr = 0xbffff4ae
[ODBC][23568][SQLError.c][438]
                Exit:[SQL_NO_DATA]
[ODBC][23568][SQLError.c][481]
                Entry:                
                        Environment = 0x804e920                
                        SQLState = 0xbffff4b0                
                        Native = 0xbffff4a8                
                        Message Text = 0xbffff4c0                
                        Buffer Length = 500                
                        Text Len Ptr = 0xbffff4ae
[ODBC][23568][SQLError.c][518]
                Exit:[SQL_NO_DATA]
[ODBC][23568][SQLFreeHandle.c][254]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x804f018
[ODBC][23568][SQLFreeHandle.c][305]
                Exit:[SQL_SUCCESS]
[ODBC][23568][SQLFreeHandle.c][188]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x804e920

contents of TDSDUMP:
2003-04-15 09:32:38.219047 iconv will convert client-side data to the ""
character set
2003-04-15 09:32:38.220719 IP address pointer is NULL
2003-04-15 09:32:38.220741 Server SYBASE not found!

ODBC.INI:
[testserver]
Driver          = TDS
Description     = Northwind sample database
Trace           = yes
Servername      = 192.168.1.15
Database        = Northwind
UID             = sa

ODBCINST.INI:
[TDS]
Description     = v0.61 with protocol v8.0
Driver          = /usr/local/freetds/lib/libtdsodbc.so
FileUsage       = 1

FREETDS.CONF:
[global]
        tds version = 4.2
        initial block size = 512
        swap broken dates = no
        swap broken money = no
        text size = 64512   
        
[testserver]
        host = testserver.foo.com
        port = 1433
        tds version = 8.0


¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤
Jeff Honey
PS Management Company
2255 Crescent Drive
Mount Dora, FL  32757
352-385-0114 x111 voice
352-385-0118 fax
¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤



More information about the FreeTDS mailing list