Set up an ASA ODBC Driver

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

Prerequisites

Install:

  • Adaptive Server Anywhere - SQL Anywhere Studio 8 or higher, and create a repository
  • ASA ODBC driver software (installed with the ASA DBMS)

Set up the ODBC Driver

Your ASA 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 'Tools | ODBC Data Sources'.

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 'Adaptive Server Anywhere' or 'SQL Anywhere' from the list.

4

Click on the Finish button.

The 'ASA Connector/ODBC' dialog displays.

5

Enter these configuration details:

  • A data source name for the connection, on the 'ODBC' tab
  • User name and password on the 'Login' tab (dba, sql are the defaults when ASA is installed)
  • The server name and the path to the database, on the 'Database' tab
  • The network protocol on the 'Network' tab (if the database is on a network location)

6

Return to the 'ODBC' tab and click on the Test Connection button to confirm that the details are correct.

7

If the test succeeds, click on the OK button to complete the configuration.

If the test does not succeed, review your settings.

Learn more