Why can I not use Move ADO connection to an Oracle database

Hello to all,

Mine is an interesting problem that appeared recently.
I am connecting to an Oracle database from an NT machine with ADO calls in a VC++ 6.0 program and receive data from it.
However, if I try to jump to specific records with the Move method of the Recordset pointer I get an exception that goes like "The operation requested by the program is not supported by the provider."

Now, if I try the same thing with an Access version of the same database, everything is fine, except the fact that it moves only if the recordset is of Keyset type. With the Oracle data source, using MSDASQL, MSDAORA or ordinary ODBC DSN makes no difference, neither does it matter what type of recordset I use. This is the statement that raises the exception:

m_pRecordset->Move(index, COleVariant((long) adBookmarkFirst));



Is there an alternative way of moving in my recordset?

Best of luck to everyone,
Hurol Aslan