problem IBM DB2 and PHP

From: Date: Thu, 17 Feb 2000 18:45:32 +0000
Subject: problem IBM DB2 and PHP
Groups: php.dev 
Request: Send a blank email to php-dev+get-15653@lists.php.net to get a copy of this message
Hi, I'm interested to interface my IBM DB2 server with an PHP3 application. Unfortunately I've many problems to connect to my database. I use - Windows NT 4.0 server with DB2 5.2 - Solaris 7 client (apache compiled using --with-ibm-db2 in PHP library) My problem is connect to the remote database. I've tried using /etc/udbc.ini file but i have the same error "Warning: SQL error: , SQL state in SQLConnect in /www/htdocs/test/db2.php3 on line 11" my odbc.ini [PROVA] Driver=/usr/local/db2/lib/libdb2.so uid=db2admin pwd=db2admin autocommit=0 TableType="'NOME','COGNOME',"INDIRIZZO'" [ODBC] Trace=0 TraceFile=odbctrace.out InstallDir=/usr/local/db2/odbclib my db2.php3 <html> <body> <? putenv("LD_LIBRARY_PATH=/usr/local/db2/lib"); putenv("UDBCINI=/etc/udbc.ini"); putenv("ODBCINI=/etc/odbc.ini"); putenv("DebugFile=/tmp/udbc.out"); $dsn="DSN=PROVA"; $user="db2admin"; $password="db2admin"; $conn_id=odbc_connect("$dsn","$user","$password"); <? </body> </html> Somebody can help me? Thank you Gabriele

« previous php.dev (#15653) next »