So, I recompiled PHP 4.2.2 to add --with-ibm-db2 and it seemed to compile w/o error and I proceeded to follow the IBM instructions provided at:
http://www7b.boulder.ibm.com/dmdd/library/techarticle/scott/0614_scott.html
which included adding a line to my /etc/ld.so.conf (the line "/etc/httpd/modules")
and also adding a line to the top of /etc/rc.d/init.d/httpd (the line being ". /home/db2inst1/sqllib/db2profile" in order to make sure apache 'inherits the db2 environment variables')
anyways... i try to run a php to connect to the database... which contains these lines (and the vars are set to the correct values):
$dbconn = odbc_connect($dbname, $username, $password);
(which is line 8 of this file...) when executed, it returns:
Warning: SQL error: , SQL state yÊT>T@XÍÿ¿9cA@°ãB in SQLConnect in /var/www/html/db2php/db2lib.php on line 8
(yes, it outputs those garbage characters)
and i can't seem to figure out what the heck the problem is.... anyone seen this kind of error before?
any help would be VERY appreciated, and of course any more detail you might need i'm happy to supply.
TIA!!!
-Doug Smith
p.s. DB2 works like a charm via command line.....
