Problem MySQL and MFC and Dynamic Cursors

--------------040706060506080701080309
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hello,

We have the following problem.
We try to use MySQL with MFC (CDatabase & CRecordset) and have to use
dynamic cursors (dynamic or dynaset open type for CRecordset constructor).
In the documentation we found out that MySQL supports the usage of
dynamic cursors and we configured the ODBC source to support dynamic
cursors by checking the enable dynamic cursor flag, we tried several
different values for the connection options namely 32, but none of them
allowed us to open the CRecordset with opentype dynamic or dynaset.
The Reason was that the MySQL driver allways reports to support only
static cursors beeing queried by SQLGetInfo with SQL_SCROLL_OPTIONS.
Is there anything we have to consider to open an ODBC connection to
MySQL with MyODBC 3.51 that supports dynamic cursors that way that the
driver reports so on SQLGetInfo with SQL_SCROLL_OPTIONS?

Thank you and kind regards,
Stefan Eder


--

Stefan Eder
Vorstand - Director

ebuconnect AG
Stadttor 1
D-40219 Düsseldorf

Office Phone +49-2181-2363-0
Phone +49-2137-799797
Fax +49-2181-2363-43
Mobile +49-172-6050486

stefan.eder@ebuconnect.de

www.ebuconnect.de


--------------040706060506080701080309
Content-Type: multipart/related;
boundary="------------070808030004000606010208"


--------------070808030004000606010208
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit








Hello,



We have the following problem.

We try to use MySQL with MFC (CDatabase & CRecordset) and have to
use dynamic cursors (dynamic or dynaset open type for CRecordset
constructor).

In the documentation we found out that MySQL supports the usage of
dynamic cursors and we configured the ODBC source to support dynamic
cursors by checking the enable dynamic cursor flag, we tried several
different values for the connection options namely 32, but none of them
allowed us to open the CRecordset with opentype dynamic or dynaset.

The Reason was that the MySQL driver allways reports to support only
static cursors beeing queried by SQLGetInfo with SQL_SCROLL_OPTIONS.

Is there anything we have to consider to open an ODBC connection to
MySQL with MyODBC 3.51 that supports dynamic cursors that way that the
driver reports so on SQLGetInfo with SQL_SCROLL_OPTIONS?



Thank you and kind regards,

Stefan Eder