Topics
Prev Next

Set up a MariaDB ODBC Driver

After you have created a repository on your MariaDB database, you set up the MariaDB ODBC driver so that you can connect to a project on that repository from Enterprise Architect.

Prerequisites

Install:

  • MariaDB DBMS and repository
  • MariaDB ODBC driver software

Set up the ODBC Driver

Your MariaDB 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 MariaDB ODBC Driver from the list.

4

Click on the Finish button.

The 'MariaDB 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