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