Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

ASA ODBC Driver

This topic explains how to set up an Adaptive Server Anywhere (ASA) ODBC driver.

Prerequisites:

You must first have installed:

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

Use to:

  • Set up the ASA ODBC driver so that you can connect to your ASA repository in Enterprise Architect

How to:

Step

Action

1

Select the WindowsTM Control Panel | Administrative Tools | Data Sources (ODBC) 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 Adaptive Server Anywhere or SQL Anywhere from the list

4

Click on the Finish button

The ASA Connector/ODBC dialog displays

5

Enter the following 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 test the connection

7

Click on the OK button to complete the configuration

Your ASA connection is now available to use in Enterprise Architect.

Notes:

  • Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC; to set up the ODBC configuration on 64-bit clients, run the 32-bit ODBC Data Source Administrator from C:\Windows\SysWOW64\odbcad32.exe

Learn More: