My Problem ended up being that i was compileing a 64 bit php with 32 bit libraries for DB2, once i was able to get the 64 bit libraries for DB2 and compile php it worked just fine after that. -Cameron -----Original Message----- From: Anni Hienola [mailto:anni.hienola@xxxxxxxxxxx] Sent: Thursday, August 26, 2004 13:31 To: php-db@xxxxxxxxxxxxx Subject: Re: ODBC_Connect error message Hello I'm having pretty much the same problem and no help from web. Im very curious to know, if you were able to solve this problem. My setup is as follows: RedHat EL WS on x86 apache 2.0.50, PHP 4.3.8 IBM UDB DB2 personal edition 8.1 PHP was configured with options --with-ibm-db2=/opt/IBM/db2/V8.1/ --with-apxs2=/usr/local/apache2/bin/apxs I also tried this with the RPM packages for apache provided by RedHat but there was no difference in behavior. The problem is in PHP, because when I use a simple script from command line to access DB2 (script below), I get the same gibberish SQL error than via web browser. Sequence of actions: launch db2profile from /home/db2inst1/sqllib (db2 instance user) restart apache from the same shell >php db2.php script db2.php <?php $conn = odbc_connect('mmtest', 'd2inst1', 'instance'); odbc_close($conn); ?> Line two gives the SQL error. Warning: odbc_connect(): SQL error: ? M?, SQL state ????d????$ D?????x???E,a;?? in SQLConnect in /usr/local/apache2/htdocs/db2.php on line 2 Any help is greatly appreciated. Anni Hienola Cameron Seader wrote: > Greetings, > I am having some trouble with this error message and finding out what it really means. I receive this in my HTTP error log from apache 1.3. > > [Tue Aug 17 23:36:04 2004] [error] PHP Warning: odbc_connect(): SQL error: , SQL state ÿÿÿþ in SQLConnect in /srv/www/htdocs/acquisuite/idxdb2.php on line 572 > > I have no idea why this is doing this. It worked on another machine, but eversince in I put it on a new machine i get this message. I am running SLES 8 for s390x on Mainframe. It is 64 bit. my configure options for PHP are: ./configure --with-apxs --enable-track-vars --with-ibm-db2=/home/db2admin/sqllib --enable-bcmath --with-zlib=yes > So i have DB2 support with DB2 Connect installed on SUSE. It has worked before on a RedHat 7.2 OS on s390x platform. Does anyone have any idea what the SQL state ÿÿÿþ means? > > TIA, > Cameron Seader > > > > [INFO] -- Access Manager: > This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
