Creating a new ODBC entry

Once a database is created, you can define an ODBC entry for it. To do this, click the ``Start'' button, then select ``Settings'' and ``Control Panel'' (refer to figure 10).

Figure 10: Starting Control Panel.

Then, double click on the item labeled ``ODBC Data Sources (32bit)''. You should see a screen similar to figure 11.

Figure 11: ODBC Data Sources Administractor screen.

Press the ``Add'' button, then select ``MySQL ODBC 3.51 Driver'' from the driver list. Refer to figure 12 for more details.

Figure 12: Choose MySQL ODBC driver.

In the DSN configuration dialog box, you can use any name as ``Data Source Name'', it is merely used to identify the data source. However, the ``Database Name'' must match the name of the database that you just created in Control Center. Do not specify any directory. Enter ``root'' as ``User'' and leave ``Password'' empty (unless you have already set up a password for root). Refer to figure 13 for a sample screen.

Figure 13: Dialog box to configure a new MySQL data source.

Click on the button labeled ``Test Data Source''. If everything is done right, you should see a message saying ``Data Source 'My Own Test' Connected Successfully to 'mysqld-4.0.14-max-debug'!!!''. Of course, your message may differ depending on your version of MySQL and the name of the database.

Press Okay buttons to exit all the way out to Windows.