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: