Configuring a Data Source for MySQL

This section explains how to configure a data source for MySQL on Windows XP. Before you can configure a data source, you must install MySQL and the MySQL ODBC driver and you must create a MySQL database to configure as the data source. Please consult your MySQL documentation for an explanation of how to do this. The procedure in this section was developed using MySQL 5.0.

Procedure 190: Configuring an ODBC Data Source for MySQL

Note: If you are running the Logger on 64-bit Windows, run C:/Windows/SysWOW64/odbcad32.exe. Then go to step 4.

  1. Open the Control Panel.

  2. Double-click Administrative Tools. The Administrative Tools folder opens (Figure 155).

  3. In the Administrative Tools folder, double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box opens (Figure 161).

    Figure 161: ODBC Data Source Administrator dialog box

    ODBC Data Source Administrator dialog box

  4. Click Add. The Create New Data Source dialog box opens (Figure 162).

    Figure 162: Create New Data Source dialog box

    Create New Data Source dialog box

  5. Select the MySQL ODBC driver.

  6. Click Finish. The Connector/ODBC version - Add Data Source Name dialog box opens.

    Figure 163: Connector ODBC version - Add Data Source Name dialog box

    Connector ODBC version - Add Data Source Name dialog box

  7. Type a name for your data source.

  8. Complete the Server, User, and Password fields.

  9. Enter the name of the database that you created for Logger data.

  10. Click OK. The new data source is displayed in the ODBC Data Source Administrator dialog box (Figure 164).

    Figure 164: ODBC Data Source Administrator dialog box

    ODBC Data Source Administrator dialog box