Oracle 8.0.3 problem with MFC -- Please Help!

We are having a tough time using Oracle 8 with MFC. Our code works fine with both Access and SQLServer, but breaks with Oracle.

We are opening the database with the CDatabase::openReadOnly flag, and opening our recordsets with AFX_DB_USE_DEFAULT_TYPE (as well as with and without CRecordset::readOnly).

Using Access or SQLServer, we are able to open the database successfully. However, with Oracle, we get an assertion failure in dbcore.cpp line 2876 in function CRecordset::VerifyCursorSupport().

The value that the Oracle driver is returning in the call to SQLGetInfo in dwDriverScrollOptions is 1 (forward only!)

How can I fix this? I want to be able to open the recordset in read-only mode but *not* forward only.

Any ideas? This sounds like it should be a simple fix -- what am I doing wrong?

Thanks,

:-)
Jason Received on Mon Apr 06 1998 - 00:00:00 CEST