Skip to Content.
Sympa Menu

freetds - RE: [freetds] SQLConnect Problem under AIX 5.1

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Rafi Sheikh <Rafi.Sheikh AT Ingenix.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] SQLConnect Problem under AIX 5.1
  • Date: Thu, 24 Jun 2004 07:52:15 -0500


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.




Archive powered by MHonArc 2.6.24.

Top of Page