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.4 (see ODBC version note below)

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
  • Ensure 'Allow saving password' is checked
  • 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
  • ODBC Version: v5.3.5 and later of the ODBC can be used however special care is required to ensure the correct Microsoft Visual Studio redistributable is installed to avoid the database driver causing errors.  For example versions 5.3.5 to 5.3.14 requires an updated version of the Visual Studio redistributable (that needs to be manually installed), in particular file msvcr120.dll should be at least v12.0.40649.5.

Learn more