From: huenerbe at dli-11 dot vcsystem dot com
Operating system: Linux 2.4.x
PHP version: 4.3.2
PHP Bug Type: ODBC related
Bug description: SAPDB ODBC Connection in SQLMode=Oracle always results in no "rows"
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 bug report at http://bugs.php.net/?id=25097&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25097&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25097&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=25097&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=25097&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=25097&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=25097&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=25097&r=support
Expected behavior: http://bugs.php.net/fix.php?id=25097&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=25097&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=25097&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=25097&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25097&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=25097&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=25097&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=25097&r=gnused
