Re: "Dynamic cursors not supported by ODBC driver" Error for dynaset CRecordset

From:

"Mark Salsbery [MVP]" <MarkSalsbery[MVP]@newsgroup.nospam>

Newsgroups:

microsoft.public.vc.mfc

Date:

Tue, 16 Oct 2007 14:04:17 -0700

Message-ID:

<#O2fegDEIHA.4544@TK2MSFTNGP06.phx.gbl>

How are you opening the database? Open()? OpenEx()?

What parameters are you passing to CDatabase::Open(Ex)?

Mark

--
Mark Salsbery
Microsoft MVP - Visual C++

"Ganga Sridhar" <gangasridhar@abosoftware.com> wrote in message
news:e49KMXDEIHA.3400@TK2MSFTNGP03.phx.gbl...

Platform: Window 2003 Server Enterprise Edition, VC 2005 , ODBC version
3.52, MDAC 2.8, MSAccess2000 database

Hello

In our multithreaded VC++ application, we are accessing certain tables
using
CRecordset (with dynaset properties set)

We are facing ODBC related error (for MS ACCESS database) i.e. "Dynamic
cursors not supported by ODBC driver". Error comes randomly, during
opening
of a table. To open the tables we use command

CRecordset::Open( CRecordset::dynaset, strSQL, CRecordset::none ).

Can someone let me know what are the reasons for this particular
CDbException error to be thrown "AFX_SQL_ERROR_DYNAMIC_CURSOR_NOT_SUPPORT"

Any pointers would be of great help.

Thanks and Regards

Ganga