problem IBM DB2 and PHP
| From: | Gabriele Forzano | 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