#25097 [Fbk]: SAPDB ODBC Connection in SQLMode=Oracle always results in no "rows"

From: Date: Fri, 15 Aug 2003 15:44:58 +0000
Subject: #25097 [Fbk]: SAPDB ODBC Connection in SQLMode=Oracle always results in no "rows"
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-45973@lists.php.net to get a copy of this message 
 ID:               25097
 Updated by:       kalowsky@php.net
 Reported By:      huenerbe at dli-11 dot vcsystem dot com
 Status:           Feedback
 Bug Type:         ODBC related
 Operating System: Linux 2.4.x
 PHP Version:      4.3.2
 New Comment:

Further more, I have no idea what SQLMode does so I haven't a clue how
to debug this.

I'm going to assume that this isn't a PHP bug, as it works for fine for
myself and others, but rather a quark in how SAPDB handles things.  

If you could turn on logging that would also help.


Previous Comments:
------------------------------------------------------------------------

[2003-08-15 08:21:05] sniper@php.net

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

------------------------------------------------------------------------

[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

Thread (4 messages)

« previous php.bugs (#45973) next »