FreeTDS Development Group

[Rafi Sheikh <Rafi.Sheikh AT Ingenix.com>]

I just realized that I did a boo boo in terms of asking Freddy directly a
newbie-panic question.  No offense was intended.  I will try to be a good
boy!

RS

-----Original Message-----
From: hany heggy [mailto:hany.hegy AT etelvaz.com]
Sent: Thursday, June 24, 2004 2:35 PM
To: FreeTDS
Subject: [freetds] SQLConnect Problem under AIX 5.1


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 ?

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.