Linux/php/DB2 : error odbc_connect...

axo92

Hi!

Our system is an apache 1.3.14 server with php 4.0.4pl1 as a loadable
module and IBM DB2 7.1 installed as a developer client, so we have to access
a remote DB2 server on a NT machine.

We have an instance ('db2inst1', the default one) that seems to work fine,
because we can catalog databases and access them using command line. Once
connected, we can perform normal SQL and sql select's return right values
from tables.

However, when we try to connect to that same database from a php script, we
get the following error message:

Warning: SQL error: , SQL state ¿Ë ?=z@éÿ¿ÛË ?=z@?=z@ in SQLConnect in
/usr/local/apache/htdocs/index.php on line 2

The script is the following

<? $connect = odbc_connect("mybase", "user", "passwd"); ?>

The script escapes through the die condition, and note that SQL state in
error message does not return a code number but random rubbish (it seems to
be a fragment of RAM content).

Can anyone help me?

Thanks in advance

method

Did you ever fix this problem? the exact same thing is happening to me with php4.0.4pl1 while trying to connect to my as/400, i can do the connection fine with command line db2 but not with php.

method

Ah! i found the problem, after upgrading my php version to make sure that wasn't the problem i browsed through one of the other articles i found on my search to make this crap all work together (http://people.a2000.nl/nlvanrey/docs/install-db2-php-apache-linux.html) which is wrong btw so don't try to set up your system based on these instructions, but i did see a piece of information that may be very helpful. he said copy the .profile and log in as db2inst1 then su root to keep the environment variables, once i did that it worked. The solution then, is to basically copy all those environment variables into whatever script calls apache. viola. please tell me if this helped 🙂