Hi,
I try to made a connection beetween a linux web server and a linux adabasD server.
I use a PHP odbc module which use odbcunix connection.
This my odbc configuration:
aribo:/home/jmangeard# cat /etc/odbc.ini
[myadabas]
Description=My adabas
Driver=adabas
ServerDB=toto
ServerNode=monserveurdetest
SqlMode=ANSI
IsolationLevel=Uncommited
TraceFileName=sampldb.pct
aribo:/home/jmangeard# cat /etc/odbcinst.ini
[adabas]
Description = adabas
Driver = /usr/local/adabas/lib/odbclib.so
[ODBC]
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes
Pooling = Yes
My PHP script:
$dsn = “DRIVER={adabas};SERVER=mytestserver;DATABASE=myadabas;UID=ODBC;”;
$conn = odbc_connect($dsn, $db_user, $db_pass);
Php output :
aribo:/home/jmangeard# php test.php
Warning: odbc_connect(): SQL error: , SQL state 00000 in SQLConnect in /home/jmangeard/test.php on line 7
The odbc log file:
[ODBC][14216][SQLDriverConnect.c][678]
Entry:
Connection = 0x86460e0
Window Hdl = (nil)
Str In = [DRIVER={adabas};SERVER=bmytestserver;DATABASE=myadabas;UID=ODBC;][length = 75]
Str Out = 0xaf80883a
Str Out Max = 1023
Str Out Ptr = 0xaf808c3a
Completion = 0
UNICODE Using encoding ASCII ‘ISO8859-1’ and UNICODE ‘UCS-2LE’
[ODBC][14216][SQLDriverConnect.c][1258]
Exit:[SQL_ERROR]
[ODBC][14216][SQLError.c][424]
Entry:
Connection = 0x86460e0
SQLState = 0xaf8087de
Native = 0xaf8087e4
Message Text = 0xaf8085de
Buffer Length = 511
Text Len Ptr = 0xaf8087ea
[ODBC][14216][SQLError.c][461]
Exit:[SQL_NO_DATA]
[ODBC][14216][SQLFreeHandle.c][268]
Entry:
Handle Type = 2
Input Handle = 0x86460e0
[ODBC][14216][SQLFreeHandle.c][317]
Exit:[SQL_SUCCESS]
Can you help me ?
This forum is my last chance to solve this problem. I have search a long time a solution to this problem on the web, but it seams to me that anyone used adabaseD with PHP or unix odbc.