Creating an ASA database interface

This topic provides details about how to create an ASA database interface.

Install Sybase ASA driver on the Windows computer

Infrastructure Management provides an application on Windows that installs the ASA ODBC drivers and creates a DSN. The following sections provide instructions on how to install the package.

Prerequisite for ASA ODBC driver installation

Microsoft Driver Manager for Windows should be available. To check if it is available, select Start > Settings > Control Panel > Administrative tools > Data sources (ODBC).

Installing the ASA ODBC driver

Perform the following procedure to install the ASA ODBC driver.

To install the ASA ODBC driver

1.  Locate ASA_Client.exe in the Utilities directory on the Infrastructure Management DVD.
2. Double-click ASA_Client.exe. 
   
   The installation package opens to install the product. The Install Wizard Welcome window is displayed and then the License window is displayed.
3. Follow the prompts until the installation directory is displayed. You can change the installation location. After selecting the installation directory click Next. 
   
   A summary of the installation is displayed.
4. After the installation is complete, click Finish to close the installation window. 
   
   The ASA ODBC driver now is installed.
5. Verify the ODBC Administrator manager for a DSN ASA Client by following these steps:
   1. Select Start > Control Panel > Administrative Tools > Data Sources (ODBC).
   2. Select the System DSN tab.
   3. Select ASA Client and click Configure. 
      
      The ODBC Configuration for Adaptive Server Anywhere window displays.
6. From the ODBC tab, you can modify the DSN to connect to the ASA database of your choice or accept the default, ASA Client.
7. From the Login tab, you can change the user name and password or accept the default report user name and password.
8. Confirm the database name by following these steps:
   1. On the Infrastructure Management Server, access the usr/pw/sybase/ directory.
   2. In the usr/pw/sybase/ directory, look for the file with the .db extension. 
      
      The name of the .db file corresponds to the name of the database. By default, the database name is storm_serverName.db. 
      
      For example, if the file is named storm_krishna.db, then the name of the server where the ASA database is running is krishna. However, you can modify the name of the database from the default.
9. From the Database tab, in the Server Name field, specify the name of the server where the database is running.
10. From the Network tab, select TCP/IP and enter the host details: host=hostName or IPaddress:2638. 
    hostName specifies the host on which the ASA database is running. 2638 is the port on which the database is listening for client connections. 
    
    For example, host=krishna:2638.
11. From the ODBC tab, test the connection by following these steps:
    1. Click Test Connection. 
       
       A message window displays that the connection is successful.
    2. Click OK to close the message window.
12. In the ODBC window, click OK. 
    
    The DSN that is created by ASA_Client.exe now is configured.