Bug #44240 [Fbk->NoF]: No data returned by ODBC
Edit report at https://bugs.php.net/bug.php?id=44240&edit=1
ID: 44240
Updated by: php-bugs@lists.php.net
Reported by: johann dot maurer at bfh dot ch
Summary: No data returned by ODBC
-Status: Feedback
+Status: No Feedback
Type: Bug
Package: ODBC related
Operating System: Win2003 SP2
PHP Version: 5.2.5
Assigned To: cmb
Private report: N
New Comment:
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.
Previous Comments:
------------------------------------------------------------------------
[2020-10-01 12:34:10] cmb@php.net
Can you still reproduce this with any of the actively supported
PHP versions[1]?
[1] <https://www.php.net/supported-versions.php>
------------------------------------------------------------------------
[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
Thread (3 messages)