I want to use Dynamic Cursors in my Application. MyODBC 3.51 supports Dynamic cursors. But Im not able to use in in conjuction with ADO 2.7.
Has anyone experience with Dynamic Cursors under MyODBC?

I open the Connection in ADO with:

"Driver={mySQL ODBC 3.51 Driver};Server=localhost;Port=3306;Database=buchon line;Uid=bol;OPTION=35"
32 to activate dynamic cursors + 3 for compatiblity

Then I open my Recordset:

m_pRecordset->CursorType = adOpenDynamic;
m_pRecordset->CursorLocation = adUseServer;
m_pRecordset->LockType = adLockOptimistic;

m_pRecordset->Open((LPCSTR)m_strQuery, _variant_t((IDispatch*)mpdb, TRUE), adOpenDynamic, adLockOptimistic, adCmdUnknown);

But when I call:


I see, that ado opened a ForwardOnly Cursor. Why?!?

Thanks for your help,

Björn Schwemmer