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

Set up an ASA ODBC Driver

After you have created a Sybase ASA database, you will need to set up an ODBC DSN to the new database in order for Enterprise Architect to connect to it.

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

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 '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' and '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