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:[EMAIL PROTECTED]
> Sent: Thursday, August 26, 2004 13:31
> To: [EMAIL PROTECTED]
> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to