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

Your MySQL driver is now available to connect to the repository from Enterprise Architect.

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.

Learn more