Strange SQL states from db2 driver

From: Date: Mon, 24 Jul 2000 19:27:30 +0000
Subject: Strange SQL states from db2 driver
Groups: php.db 
Request: Send a blank email to php-db+get-1441@lists.php.net to get a copy of this message
I downloaded and compiled php 4.01pl2 with the ibmdb2 configure switch, and got php working fine. However, when I try to connect to a databse, I get random noise for error messages. Here is one of the error messages I recevied: Warning: SQL error: , SQL state ‰N+@ in SQLConnect in /opt/IBMHTTPServer/htdocs/php/dbtest.php on line 2 it alternates back and forth between that and Warning: SQL error: , SQL state ‰N+@$�Ðùÿ¿§N+@ in SQLConnect in /opt/IBMHTTPServer/htdocs/php/dbtest.php on line 2 I can generate other error messages, but why the heck are they encoded like that? using a hex editor, I discovered the hex chars, and the hex chars don't match any SQL states that db2 has. Is this caused by a pointer misuse in db2, or something? sometimes I get strange things like: Warning: SQL error: , SQL state ‰N+@ESSIÐùÿ¿§N+@PHPSESSI in SQLConnect in /opt/IBMHTTPServer/htdocs/php/dbtest.php on line 2 Which make me suspicious that it is a pointer error (because of the PHP SESSI). Anyway, sql developers, take a look at this, I kind of want to know WHY it won't connect :P Ben Zeigler

« previous php.db (#1441) next »