My system is 32-bit, so I guess PHP configured itself as 32-bit when I compiled it. So that wasn't quite like my problem. Anyway this suggests that the PHP compilation is the key here. Looking at the configure help I couldn't even start guessing what I could possibly change. I try to play around with the optimization flags, first. If somebody has any suggestions, I would very much like to hear them. Anni H. On Sun, 2004-08-29 at 15:47, Seader, Cameron wrote: > 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
