|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2003-08-15 08:21 UTC] sniper@php.net
[2003-08-15 10:44 UTC] kalowsky@php.net
[2003-08-20 23:59 UTC] sniper@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 01 18:00:01 2025 UTC |
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>