MySQL ODBC Driver

This topic explains how to set up a MySQL ODBC driver.

Prerequisites:

You must first have installed:

  • Microsoft MDAC components
  • MySQL DBMS and repository
  • MySQL ODBC driver software version 5.1.5 (version 3.51.14 creates problems in incorporating tests in elements)

Use to:

  • Set up the MySQL ODBC driver so that you can connect to your MySQL repository in Enterprise Architect

How to:

Step

Action

1

Select the WindowsTM Control Panel | Administrative Tools | Data Sources (ODBC) option

The ODBC Data Source Administrator window displays

2

Click on the Add button

The Create New Data Source dialog displays, enabling you to add a new DSN

3

Select MySQL ODBC 5.1 Driver from the list

4

Click on the Finish button

The MySQL Connector/ODBC dialog displays

5

Enter the following configuration details:

  • A data source name for the connection
  • A description (optional)
  • The host address of the DBMS server
  • User name and password
  • The database name on the selected server

6

To set the advanced options, click on the Details>> button

7

Select the following checkboxes (where provided):

  • Return matched rows instead of affected rows (Connection or Cursors/Results tab)
  • Allow big result sets (Connection tab)

8

Click on the Test Connection button to confirm that the details are correct

9

  • If the test succeeds, click on the OK button to complete the configuration
  • If the test does not succeed, review your settings

Your MySQL connection is now available to use in Enterprise Architect.

Notes:

  • Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC; to set up the ODBC configuration on 64-bit clients, run the 32-bit ODBC Data Source Administrator from C:\Windows\SysWOW64\odbcad32.exe

Learn More: