ODBC usage

发表于 分类于 阅读次数： 本文字数： 950 阅读时长 ≈ 1 分钟

use ODBC by MFC

website

work with class CDatabase,the data source must be one that you have configured through Open Database Connectivity (ODBC) Administrator.

use ODBC connect MySql.
MySql ODBC driver
for now mysql-connector-odbc-8.0.15-winx64.msi

Configuring a Connector/ODBC DSN on Windows with the ODBC Data Source Administrator GUI

Open the ODBC Data Source Administrator.
9240a845.png

To create a System DSN (which will be available to all users), select the System DSN tab. To create a User DSN, which will be available only to the current user, click the Add… button to open the “Create New Data Source” dialog.

From the “Create New Data Source” dialog, select the MySQL ODBC 5.x ANSI or Unicode Driver, then click Finish to open its connection parameters dialog.

9e83225a.png

You now need to configure the specific fields for the DSN you are creating through the Connection Parameters dialog.

4bc71c97.png

To verify the connection using the parameters you have entered, click the Test button. If the connection can be made successfully, you will be notified with a Connection Successful dialog; otherwise, you will be notified with a Connection Failed dialog.