ASA Database Administration Guide
  Connecting to a Database
    Troubleshooting connections

The steps in establishing a connection

To establish a connection, Adaptive Server Anywhere carries out the following steps in order:

1. Locate the interface library    The client application must locate the ODBC driver or Embedded SQL interface library.

2. Assemble a list of connection parameters    Since connection parameters may appear in several places (such as data sources, a connection string assembled by the application, or an environment variable) Adaptive Server Anywhere assembles the parameters into a single list.

3. Locate a server    Using the connection parameters, Adaptive Server Anywhere locates a database server on your machine or over a network.

4. Locate the database    Adaptive Server Anywhere locates the database you want to connect to.

5. Start a personal server    If Adaptive Server Anywhere fails to locate a server, it attempts to start a personal database server and load the database.

The following sections describe each of these steps in detail.