ASA Database Administration Guide
  Running the Database Server
    Running the server outside the current session
      Configuring services

Adding new databases to a service

Each network server or personal server can run more than one database. If you wish to run more than one database at a time, we recommend that you do so by attaching new databases to your existing service, rather than by creating new services.

To add a new database to a service

1. In the left pane, select the Adaptive Server Anywhere plug-in.

2. In the right pane, click the Services tab.

3. Right-click the service and choose Properties from the popup menu.

4. Click the Configuration tab.

5. Add the path and filename of the new database to the end of the list of options in the Parameters box.

6. Click OK to save the changes.

   The new database starts the next time the service starts.

Databases can be started on running servers by client applications, such as Interactive SQL.

For more information about how to start a database on a server from Interactive SQL, see START DATABASE statement.

For more information about how to implement this function in an Embedded SQL application, see db_start_database function.

Starting a database from an application does not attach it to the service. If the service is stopped and restarted, the additional database will not be started automatically.