PHPLIB / Support Requests / #10 ODBC error

#10 ODBC error

Status: closed

Owner:

Labels: None

Priority: 5

Updated: 2003-09-10

Created: 2002-09-05

Creator: Anonymous

Private: No

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.

Discussion

Anonymous - 2002-09-06

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.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nobody/Anonymous - 2002-09-09

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.)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2003-09-10

assigned_to: nobody --> chaska

status: open --> closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2003-09-10

Logged In: YES
user_id=279065

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

ODBC error

Group

Searches

Help

#10 ODBC error

Discussion