#10 ODBC error

closed
None
5
2003-09-10
2002-09-05
Anonymous
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.

     
  • Nobody/Anonymous

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

     
  • Anonymous - 2003-09-10
    • assigned_to: nobody --> chaska
    • status: open --> closed
     
  • 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.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks