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

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

Support Requests item #605267, was opened at 2002-09-05 16:23
Message generated for change (Comment added) made by chaska
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403612&aid=605267&group_id=31885

Category: None
Group: None
>Status: Closed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
>Assigned to: Chris Johnson (chaska)
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: Chris Johnson (chaska)
Date: 2003-09-09 22:37

Message:
Logged In: YES 
user_id=279065

I am not sure where the problem lies, but it's definitely

not with PHPLIB.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2002-09-09 08: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 10: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