Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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:
|
||||||||||
6 |
To set the advanced options, click on the Details>> button.
|
||||||||||
7 |
Select the following checkboxes (where provided):
|
||||||||||
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