New in version 3.1.40 you will no longer need a DSN to connect to your MySQL database when building the project. You will only the need the following information below to connect. If you have any problems then try connecting with a DSN in which case you will need to follow step 4 below.
1Open the Control Panel and double-click the icon labeled
ODBC 32 OR 32bit ODBC or, in Windows NT, just ODBC. The ODBC Data
Source Administrator box is displayed. New in version 3.1.20 we have
added the ability to open the DSN Manager within ASaP so that you
can configure your local DSN. Simply click on the DSN Manager
button and then configure your DSN as you would do normally.
2Click the "System DSN" tab.
3click the Add button.
4The Create New Data Source dialog box appears Scroll down and click the name of the driver that goes with your database. In the case of Microsft Access click the entry that looks like this: Microsoft Access Driver (*.mdb). If you choose to use the DSN option then you will need to download the drivers in order to connect to a remote MySQL database. You can get the MyODBC driver from the MySQL site http://www.mysql.com/downloads/api-myodbc-3.51.html . Scroll down the MySQL page until you see Windows Downloads and choose Driver Installer download. You can now download MyODBC from the data-asap site http://www.data-asap.com/downloads/MyODBC-351.exe. After installing the driver you will then need to open your ODBC client and create a DSN to your MySQL database. The DSN will allow you to connect to your remote or local copy of your database. You will need to supply the following within the ODBC client:
6Click Finish.
7 Type the name you want to give this database in Data Source Name. You don't have to give the data source the same name you gave the database when you created it. But doing so can help you keep them all straight.
8Click the Select button. A Select Database dialog box appears.
9Rummage through your directories and find the database you created. Click OK.
10Click OK.
11Find the new DSN you just created (they're in a alphabetical order). Click OK.
Congratulations! You now have a DSN established to access your database.