Error Message on "Keyset-driven cursors"

[SIGBO]

I am using Business Objects with an Oracle (8.1.7) database, linked via the Oracle ODBC driver.

When I try to run freehand sql I get the following message :

[Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set0

If I run the same SQL in SQL Plus it works without a problem.

If I try to set up a Universe on this database and run the Check Integrity it comes up with "Parse Failed" errors under the "Parse Join" category.

This is a new problem on a database that previously worked without a problem.

Any help would be appreciated.

 

[SIGBO]

In the meantime I have resolved this issue (with the help of Oracle Support) It meant replacing the ODBC Driver with the version from the Oracle Installation disk (rather than the standard Microsoft one)

Apparently you also need to have the Net8 version and Oracle ODBC Driver version with the same 1st three digits (e.g. 8.1.7.....)