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



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

Reply via email to