From: johann dot maurer at bfh dot ch
Operating system: Win2003 SP2
PHP version: 5.2.5
PHP Bug Type: ODBC related
Bug description: No data returned by ODBC
Description:
------------
OS: Win2003 SP2
IIS: 6.0.3790
ISAPI - connection
No data is returned from DB (Sybase-Anywhere) over ODBC interface since
running php 5.2.5. Connection and select are OK, but no data is returned.
I tested without changing anything on the ODBC setup, only switched
PHP-Version, restarted iis.
Thanks
Johann
Reproduce code:
---------------
<?php
$dbo = odbc_connect( 'rektor-php','odbc_test','tester');
echo "odbc = $dbo <br>";
$qry = "select * from rektor.odbc_Test where Data like 'a%' ";
echo "qry = $qry <br>\n";
$dbid = odbc_exec($dbo,$qry);
echo "dbid = $dbid <br>";
$res = odbc_result_all($dbid);
if ($res == false) echo 'fetch = false! <br>';
echo "fetch = '$res' <br>";
print_r($a_res);
odbc_free_result($dbid);
?>
Expected result:
----------------
Testoutput with php 5.1.2
-------------------------
odbc = Resource id #3
qry = select * from rektor.odbc_Test where Data like 'a%'
dbid = Resource id #4
ColID Data
1 aaaaaaaaa
2 abcdefgh
fetch = '2'
Actual result:
--------------
Testoutput with php 5.2.5
-------------------------
odbc = Resource id #3
qry = select * from rektor.odbc_Test where Data like 'a%'
dbid = Resource id #4
ColID Data
fetch = '2'
Comment: Two blank rows returned.
--
Edit bug report at http://bugs.php.net/?id=44240&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=44240&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=44240&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=44240&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=44240&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=44240&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=44240&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=44240&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=44240&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=44240&r=support
Expected behavior: http://bugs.php.net/fix.php?id=44240&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=44240&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=44240&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=44240&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=44240&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=44240&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=44240&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=44240&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=44240&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=44240&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=44240&r=mysqlcfg
