Bug #1246: odbc_fetch_row fails most times

From: stefan.ohrhallinger@beko.at Operating system: Linux 2.0.36/SuSE 6.0 PHP version: 3.0.7 PHP Bug Type: Oracle related Bug description: odbc_fetch_row fails most times php3-script: <?php $db = odbc_connect("tennisliste-ora", "stef", "stef"); ?> $ortnr = 1; $ort = odbc_prepare($db, "select beschreibung from ort where ortnr=$ortnr"); odbc_execute($ort); $row = odbc_fetch_row($ort); if ($row) echo "ort: $row"; else echo "fetch failed"; ?> --------------------- php3-configure-line: ./configure --with-shared-apache=/home/stef/apache --with-iodbc=/home/stef/iodbc/iodbc --with-mysql=/home/stef/mysql ----------------------- no alterations to any ini file, I run it as a module within apache 1.3.4 ---------------------- The following setup is used: Oracle Server under NT, with HotSockets ODBC Driver (middleware), I connect from he Linux via iODBC Driver Manager and HotSockets ODBC Driver. The query above works 100% of the time when using a cmdline odbc test-tool, thru apache/php3 it fails 50-90% of the time, I couldn´t make out any relevant factors. When using the same php3-script with the mysql database on the same machine, it works 100% as well. My guess is that there are some quirks in the functions/unified_odbc.c - I already had to get rid of the trying to set dynamic cursors to get mysql to work. -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net