[freetds] SQLConnect Problem under AIX 5.1

hany heggy hany.hegy at etelvaz.com
Thu Jun 24 15:35:10 EDT 2004


hi,

i have installed unixODBC 2.2.9 under AIX 5.1.5 and it words fine with
DB2 Driver 

i have installed FreeTDS 0.62.4 and the build work fine and i get the
shared object created ( /usr/local/lib/libtdsodbc.so )


while trying to connect to MS SQL server using isql it give this error:

./isql -v syria sa  sa_password
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect



i enabled the trace and i got this trace file :

[ODBC][19988][__handles.c][421]
                Exit:[SQL_SUCCESS]
                        Environment = 2020e968
[ODBC][19988][SQLAllocHandle.c][345]
                Entry:
                        Handle Type = 2
                        Input Handle = 2020e968
[ODBC][19988][SQLAllocHandle.c][463]
                Exit:[SQL_SUCCESS]
                        Output Handle = 2020f148
[ODBC][19988][SQLConnect.c][3452]
                Entry:
                        Connection = 2020f148
                        Server Name = [syria][length = 5 (SQL_NTS)]
                        User Name = [sa][length = 2 (SQL_NTS)]
                        Authentication = [*********][length = 9
(SQL_NTS)]
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
'UCS-2'

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

[ODBC][19988][SQLConnect.c][3820]
                Exit:[SQL_ERROR]
[ODBC][19988][SQLError.c][424]
                Entry:
                        Connection = 2020f148
                        SQLState = 2ff226d8
                        Native = 2ff226ec
                        Message Text = 2ff224e0
                        Buffer Length = 500
                        Text Len Ptr = 2ff226e8
[ODBC][19988][SQLError.c][461]
                Exit:[SQL_SUCCESS]
                        SQLState = S1000
                        Native = 2ff226ec -> 0
                        Message Text = [[unixODBC][FreeTDS][SQL
Server]Unable to connect to data source]
[ODBC][19988][SQLError.c][424]
                Entry:
                        Connection = 2020f148
                        SQLState = 2ff226d8
                        Native = 2ff226ec
                        Message Text = 2ff224e0
                        Buffer Length = 500
                        Text Len Ptr = 2ff226e8

[ODBC][19988][SQLError.c][461]
                Exit:[SQL_NO_DATA]
[ODBC][19988][SQLError.c][504]
                Entry:
                        Environment = 2020e968
                        SQLState = 2ff226d8
                        Native = 2ff226ec
                        Message Text = 2ff224e0
                        Buffer Length = 500
                        Text Len Ptr = 2ff226e8
[ODBC][19988][SQLError.c][541]
                Exit:[SQL_NO_DATA]
[ODBC][19988][SQLFreeHandle.c][268]
                Entry:
                        Handle Type = 2
                        Input Handle = 2020f148
[ODBC][19988][SQLFreeHandle.c][317]
                Exit:[SQL_SUCCESS]
[ODBC][19988][SQLFreeHandle.c][203]
                Entry:
                        Handle Type = 1
                        Input Handle = 2020e968


any ideas ?




More information about the FreeTDS mailing list