Set up a MySQL ODBC Driver

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.