RE: [PHP-DB] Re: ODBC_Connect error message

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@helsinki.fi] > Sent: Thursday, August 26, 2004 13:31 > To: php-db@lists.php.net > Subject: [PHP-DB] 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