Use ODBC to connect MySQL database in vc++6.0

The following figure is the final effect of the program, including the display of data, add, modify, delete the common functions of these database operations.

My debugging environment is Xp,mysql version is mysql4.0.23

1. Install MySQL-driven ODBC

Downloading drivers from http://www.mysql.com

Address: Http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32

I am a download of Windows Zip/setup.exe

After downloading to this machine, extract the Setup.exe file from the zip package, double-click the installation, nothing to say, complete the fool-type installation

2. Set up an ODBC data source

There are two ways to configure MySQL's ODBC data source

First: Manual setting

It's a bit of a hassle, but it's a safer approach.

The steps are as follows:

Start-> Control Panel-> management tools-> Data Source (ODBC), and then double-click the Data Source (ODBC) to come up with the following interface

Clicking the "Add" button in the upper-right corner will show the following interface