#38894 [NEW]: Can't fetch data(PHP+Birdstep RDM server across ODBC)

From: m dot karoly at martondesign dot com Operating system: winxpprof PHP version: 5.1.6 PHP Bug Type: ODBC related Bug description: Can't fetch data(PHP+Birdstep RDM server across ODBC) Description: ------------ The code i commented well, see below. Short description: When i try to make a SELECT, and get the rows, the odbc_fetch_rows, odbc_fetch_array, odbc_result_all returns FALSE. The connection works, the schema, table, columnnames i can receive in php. Platforms i tested: Php 4.4.4 + Velocis (2.1) = Everythings work Php 5.1.6 + Velocis (2.1) = Not working Php 4.4.4 + Birdstep (6.0) = Not working Php 5.1.6 + Birdstep (6.0) = Not working Php 5.2.x-dev + Birdstep (6.0) = Not working Reproduce code: --------------- <?php $conn = odbc_connect("RDS","username","password", SQL_CUR_USE_ODBC ); // When i connect to the dsn, everything is ok. (returns with a resource id) $odbc_result = odbc_columns($conn); // When make a query to get the "schema.table name.column name". (returns with a resource id) while (odbc_fetch_row($result)){ // in this case the odbc_fetch_row is working, but if i pass a odbc_exec return value as a parameter, it won't echo"<br>".odbc_result($result,"TABLE_SCHEM").'.'.odbc_result($result,"TABLE_NAME").".".odbc_result($result,"COLUMN_NAME"); } $odbc_result = odbc_exec($conn, "SELECT * FROM schema.table"); // When i make a query, it seems to be ok too. (returns with a resource id) odbc_result_all($odbc_result); // but -as i mentioned above - if i fetch the result of an odbc_exec (or odbc_do) query, it returns with FALSE // doesn't matter what fetch function i call, none of them returns data (odbc_fetch_array, odbc_fetch_row, odbc_result_all...) ?> Expected result: ---------------- odbc_fetch_array: returns array odbc_fetch_row: returns string odbc_result_all: returns html table Actual result: -------------- odbc_fetch_array: returns false odbc_fetch_row: returns false odbc_result_all: returns false -- Edit bug report at http://bugs.php.net/?id=38894&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38894&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38894&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38894&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38894&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38894&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38894&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38894&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38894&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38894&r=support Expected behavior: http://bugs.php.net/fix.php?id=38894&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38894&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38894&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38894&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38894&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38894&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38894&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38894&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38894&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38894&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38894&r=mysqlcfg