Contents Index Introduction Lesson 2: Connect to the sample database from Interactive SQL

Introducing SQL Anywhere Studio
   Tutorial: Connecting to the Sample Database

Lesson 1: Start the database server


This section describes how to start the database server running the sample database. In the documentation, starting a database is often used as a convenient way of saying starting a database server running a database . Depending on the operating system you are using, you have a choice of how to start the database server running the sample database.

Start the database server running the sample database (Windows)

Start the database server running the sample database (Command prompt)

  1. At a command prompt, change to your SQL Anywhere installation directory. On Windows operating systems, the default installation directory is C:\Program Files\Sybase\SQL Anywhere 9.

  2. 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.

    The database server starts.

You can display the database server window in Windows by double-clicking the Adaptive Server Anywhere icon in the system tray at the bottom of your screen.

The Adaptive Server Anywhere database server window.

The server window displays the following information:

In this case, the startup cache size and page size are the default values. For many purposes, default startup options are fine. For more advanced use, you can provide explicit database server startup options.

For a complete list of startup options, see The database server.

Next step 

The database server is ready to accept connections from database applications. In the next lesson, you connect to the sample database from the Interactive SQL database administration utility.


Contents Index Introduction Lesson 2: Connect to the sample database from Interactive SQL