Book a Demo

Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

Set up a MySQL ODBC Driver

After you have created a MySQL database, you will need to set up an ODBC DSN to the new database in order for Enterprise Architect to connect to it.

Prerequisites

Install:

  • MySQL DBMS and repository
  • MySQL 32bit ODBC driver, between versions 5.2.4 and 5.3.6

Set up the ODBC Driver

Step

Action

1

Under both 32-bit and 64-bit operating systems, Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC. You can quickly load the correct 32-bit ODBC Data Source Administrator by selecting the 'Configure > User Tools > ODBC Data Sources' ribbon 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 the appropriate MySQL ODBC Driver from the list.

4

Click on the Finish button.

The 'MySQL Connector/ODBC' dialog displays.

5

Enter these 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 these 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.

Notes

  • Connecting to DBMS based Repositories is available in the Enterprise Architect Corporate, Unified and Ultimate editions

Learn more