Bug #44240 [Opn->Fbk]: No data returned by ODBC

Edit report at https://bugs.php.net/bug.php?id=44240&edit=1 ID: 44240 Updated by: cmb@php.net Reported by: johann dot maurer at bfh dot ch Summary: No data returned by ODBC -Status: Open +Status: Feedback Type: Bug Package: ODBC related Operating System: Win2003 SP2 PHP Version: 5.2.5 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: Can you still reproduce this with any of the actively supported PHP versions[1]? [1] <https://www.php.net/supported-versions.php> Previous Comments: ------------------------------------------------------------------------ [2008-02-25 08:32:24] johann dot maurer at bfh dot ch 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 this bug report at https://bugs.php.net/bug.php?id=44240&edit=1