 | | | Problem MySQL and MFC and Dynamic Cursors | Problem MySQL and MFC and Dynamic Cursors 2005-05-20 - By Stefan Eder
Back
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@(protected) <mailto:stefan.eder@(protected)>
www.ebuconnect.de <http://www.ebuconnect.de/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
We have the following problem.<br>
We try to use MySQL with MFC (CDatabase & CRecordset) and have to
use dynamic cursors (dynamic or dynaset open type for CRecordset
constructor).<br>
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.<br>
The Reason was that the MySQL driver allways reports to support only
static cursors beeing queried by SQLGetInfo with SQL_SCROLL_OPTIONS.<br>
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?<br>
<br>
Thank you and kind regards,<br>
Stefan Eder<br>
<br>
<br>
<div class="moz-signature">-- <br>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<title>MailSignature</title>
<small> <span>
<table
style="color: rgb(153, 153, 153); font-family: arial; font-size: small;">
<tbody>
<tr>
<td colspan="2">Stefan Eder</td>
</tr>
<tr style="font-size: x-small;">
<td colspan="2">Vorstand - Director</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2">ebuconnect AG</td>
</tr>
<tr>
<td colspan="2">Stadttor 1</td>
</tr>
<tr>
<td colspan="2">D-40219 Düsseldorf</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>Office Phone </td>
<td>+49-2181-2363-0</td>
</tr>
<tr>
<td>Phone </td>
<td>+49-2137-799797</td>
</tr>
<tr>
<td>Fax </td>
<td>+49-2181-2363-43</td>
</tr>
<tr>
<td>Mobile </td>
<td>+49-172-6050486</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"> <a style="text-decoration: none;"
href="mailto:stefan.eder@(protected)">stefan.eder@(protected)</a> </td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"> <a href="http://www.ebuconnect.de/"> <img
style="width: 166px; height: 66px;" alt="www.ebuconnect.de"
src="cid:part1.09060801.02080106@(protected)" border="0"> </a> </td>
</tr>
</tbody>
</table>
</span> </small></div>
</body>
</html>
Earn $52 per hosting referral at Lunarpages.
|
|
|