ID: 25097 Updated by: [EMAIL PROTECTED] Reported By: huenerbe at dli-11 dot vcsystem dot com -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: Linux 2.4.x PHP Version: 4.3.2 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-08-15 08:17:34] huenerbe at dli-11 dot vcsystem dot com Description: ------------ All result-sets querying a SAPDB (via ODBC SQLMode=ORACLE) end up in "no rows" returned. These results contain the correct table-headers but no data. Switching to SQLMode=INTERNAL returns correct data. This seems to be a PHP related problem as I tried the php internal odbc manager and iODBC. SQLMode is working fine in other tools such as SAPDB SQL-Studio & connection via jdbc. I was able to reproduce this problem on PHP versions 4.3.2 & 5.0.0b1. Reproduce code: --------------- .odbc.ini --- [cldb01] Driver = /public/project/sapdb/indep_prog/lib/libsqlod.so Description = SAPDB cldb01 DSN = cldb01 Servername = localhost ServerDB = cldb01 SQLMode = oracle odbctest.php --- <? $con = odbc_connect("cldb01","dba","dba"); $res = odbc_do($con,"SELECT * FROM users"); odbc_result_all($res); ?> Expected result: ---------------- I expect to see a list of all users in my database, like this: OWNER GROUPNAME USERNAME USERMODE CONNECTMODE MAXTIMEOUT COSTWARNING COSTLIMIT DEFAULTCODE CREATEDATE CREATETIME ALTERDATE ALTERTIME PWCREADATE PWCREATIME SERVERDB SERVERNODE USER_ID COMMENT DBA DBA SYSDBA DEFAULT 2003-08-15 14:32:56 2003-08-15 14:32:56 CLDB01 andrea 10 DBA HUENERBE RESOURCE MULTIPLE DEFAULT 2003-08-15 14:43:59 2003-08-15 14:43:59 2003-08-15 14:43:59 CLDB01 andrea 13 DBA DBM ADMIN DEFAULT 2003-08-15 14:32:56 2003-08-15 14:32:56 CLDB01 andrea 0 Actual result: -------------- <h2>No rows found</h2> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=25097&edit=1
