[Phplib-trackers] [ phplib-Support Requests-605267 ] ODBC error

[<no...@so...>]

Support Requests item #605267, was opened at 2002-09-05 14:23
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403612&aid=605267&group_id=31885

Category: None
Group: None
Status: Open
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: ODBC error

Initial Comment:
Please help !!

Using a slightly complicated SQL statement with an 
ORACLE ODBC connection, I am getting the following 
error message:

SQL error: [Microsoft][ODBC driver for Oracle]Cannot 
use Keyset-driven cursor on join, with distinct clause, 
union, intersect or minus or on read only result set, SQL 
state S1C00 in SQLExecDirect in 
d:\apps\web\phplib\php\db_odbc.inc on line 61

I don't think it's the ODBC data drive or data source 
since it seems to work fine with Crystal Reports and 
ORACLE PL/SQL app.

Just wondering if it's a limitation in PHP or PHPLIB. 
Thank you in advance for your assistance.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2002-09-09 06:06

Message:
Logged In: NO 

Thanks for your help !!
THe troubling thing for me though is the same ODBC DSN 
works fine when used with ORACLE and other DB apps 
(Crystal Reports, etc.)

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

Comment By: Chris Johnson (chaska)
Date: 2002-09-06 08:40

Message:
Logged In: YES 
user_id=279065

This is not a PHP or PHPLIB limitation, as far as I can tell.  The 
error message looks like it was generated by a Microsoft ODBC 
driver, so I would suspect the ODBC driver as the most likely 
culprit.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403612&aid=605267&group_id=31885