Skip to Content.
Sympa Menu

freetds - [freetds] SQLConnect Problem under AIX 5.1

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: hany heggy <hany.hegy AT etelvaz.com>
  • To: FreeTDS <freetds AT lists.ibiblio.org>
  • Subject: [freetds] SQLConnect Problem under AIX 5.1
  • Date: 24 Jun 2004 15:35:10 -0400

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 ?





Archive powered by MHonArc 2.6.24.

Top of Page