Re: can i use --with-unixODBC instead of --with-ibm-db2?

Dan, Thank you for the link.... unfortunately, even after initally logging in as db2inst1 and then su to root (w/o the dash) and stopping/starting apachectl -- i still had no luck :/ same old error: "Warning: SQL error: , SQL state ËtøO@ÈØÿ¿6#A@ in SQLConnect in /var/www/html/db2php/db2lib.php on line 11" Thank you very much though still, i appreciate the ideas :) -Doug "Dan Vande More" <dvm@gwtr.com> wrote in message news:28EFB700AD814242B33D7E3FABB7969D095E22@mail.gwtr.com... I used this: Some of his info is wrong, or I had problems with, but hey, this worked: **************************************************************************** **************************************************************************** ***** Now we know DB2 works now to test it with PHP and Apache, first login as user db2inst1 then su to the user root, dont use su - , cause this will make the shell use the settings of root instead of db2inst1 and we need those settings so Apache can find the DB2 Instances. Now first stop apache (if started ofcourse) /usr/local/apache/bin/apachectl stop and start apache /usr/local/apache/bin/apachectl start . Now create a file in de apache docroot ( on my machine thats /usr/local/apache/htdocs/ ) called test.php for example and fill it with the following example: **************************************************************************** **************************************************************************** ***** http://people.a2000.nl/nlvanrey/docs/install-db2-php-apache-linux.html -----Original Message----- From: Doug Smith [mailto:doug.smith@nth-dimension.com] Sent: Thursday, August 08, 2002 1:28 PM To: php-general@lists.php.net Subject: Re: [PHP] can i use --with-unixODBC instead of --with-ibm-db2? > I just checked my config, and I *actually* have that line in apachectl. Try > that, and if it fixes it, I'll correct the doc. although my apache is built via rpm, i put the line (. /home/db2inst1/sqllib/db2profile) in apachectl and started httpd w/ apachectl, buuuut... unfortunately i'm still getting the Warning: SQL error: , SQL state ËtøO@Ùÿ¿6#A@ in SQLConnect in /var/www/html/db2php/db2lib.php on line 8 error... i also tried to add "export DB2INSTANCE=db2inst1" in the same script and that didn't help either. could the problem be that i'm starting httpd (or apachectl) as root? i know the ". /home/db2inst1/sqllib/db2profile" is supposed to make apachectl inherit the db2 environment variables, but...... somehow it's not working :/ matt, thank you again :) -doug p.s. for the record__________________________ ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbind ir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/includ e --libdir=/usr/lib --sysconfdir=/etc --with-apxs=/usr/sbin/apxs --with-ibm- db2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php