[unixODBC-support] AdabasD with unixODBC

Ray Ramsaroop ray at exoticgarden.de
Tue Mar 11 17:10:51 GMT 2008


Hello,

I'm trying to configure AdabasD with unixODBC, PHP5

odbcinst.ini:
-------------------------
[ODBC]
TraceFile = /tmp/sql.log
Trace = Yes

[AdabasD]
Description=AdabasD ODBC Driver
Driver=/usr/lib/unixODBC/odbclib.so

odbc.ini
----------------------------
[GMARKT]
Driver=AdabasD
Serverdb=GMARKT
Servernode=192.168.1.2
SqlMode=ANSI
IsolationLevel=Uncommited
TraceFileName=gmarkt.pct

testing with "isql -v GMARKT user pswrd" reslts 
[ISQL]ERROR: Could not SQLConnect

/tmp/sql.log
------------------------------------
[ODBC][3523][__handles.c][447]
                Exit:[SQL_SUCCESS]
                        Environment = 0x8051388
[ODBC][3523][SQLAllocHandle.c][359]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x8051388
[ODBC][3523][SQLAllocHandle.c][477]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x8051918
[ODBC][3523][SQLConnect.c][3587]
                Entry:
                        Connection = 0x8051918
                        Server Name = [GMARKT][length = 6 (SQL_NTS)]
                        User Name = [intranet][length = 8 (SQL_NTS)]
                        Authentication = [******][length = 6 (SQL_NTS)]
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 
'UCS-2LE'

[ODBC][3523][SQLConnect.c][3955]
                Exit:[SQL_ERROR]
[ODBC][3523][SQLError.c][424]
                Entry:
                        Connection = 0x8051918
                        SQLState = 0xbf93068e
                        Native = 0xbf930490
                        Message Text = 0xbf930499
                        Buffer Length = 500
                        Text Len Ptr = 0xbf930496
[ODBC][3523][SQLError.c][461]
                Exit:[SQL_NO_DATA]
[ODBC][3523][SQLError.c][504]
                Entry:
                        Environment = 0x8051388
                        SQLState = 0xbf93068e
                        Native = 0xbf930490
                        Message Text = 0xbf930499
                        Buffer Length = 500
                        Text Len Ptr = 0xbf930496
[ODBC][3523][SQLError.c][541]
                Exit:[SQL_NO_DATA]
[ODBC][3523][SQLFreeHandle.c][273]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x8051918
[ODBC][3523][SQLFreeHandle.c][324]
                Exit:[SQL_SUCCESS]
[ODBC][3523][SQLFreeHandle.c][206]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x8051388
---------------------------------------------
The system is OpenSuse 10.3

hope someone can help

Ray Ramsaroop






More information about the unixODBC-support mailing list