ASA Getting Started
   Adaptive Server Anywhere Quick Start

Step 1: Start the Adaptive Server Anywhere database server

In this section you start the Adaptive Server Anywhere database server running the sample database.

Adaptive Server Anywhere includes two versions of the database server. The personal database server is provided for single-user, same-machine use. The network database server supports client/server communication over a network and is provided for multi-user operation. The two database servers are exactly equivalent in their query processing and other internal operations: the personal database server is not less powerful than the network database server.

Adaptive Server Anywhere databases are held in operating system files. The sample database is held in a file named asademo.db in your SQL Anywhere installation directory.

To start the personal database server running the sample database (Windows)

• From the Start menu, choose Programs > SQL Anywhere 9 > Adaptive Server Anywhere > Personal Server Sample.

  The database server window appears.

To start the database server running the sample database (Command line)

1. Open a command prompt.

2. Change the directory to the SQL Anywhere installation directory.

   On Windows operating systems, the default installation directory is C:\Program Files\Sybase\SQL Anywhere 9.

3. Start the database server running the sample database.

   The way you start the database server depends on your operating system, and on whether you wish to connect to the database from other machines on the network.

   • If you wish to connect only from the same machine on Windows or UNIX operating systems, enter the following command to start the personal database server:

     dbeng9 -n asademo9 asademo.db

   • If you wish to connect to the database server from other machines on the network on Windows or UNIX operating systems, enter the following command to start the network database server:

     dbsrv9 -n asademo9 asademo.db

   • On NetWare, only the network database server is provided. Enter the following command:

     load dbsrv9.nlm -n asademo9 asademo.db

   The database server window appears.

For a complete list of options you can use when starting the database server, see The database server.