Lesson 2: Connecting to the database

Connect to the sample database by using Sybase Central.

Prerequisites

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Connecting to the sample database.

Start Sybase Central. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.
Click Connections » Connect With SQL Anywhere 16.
Complete the following fields to connect to the sample database:
1. In the User ID field, type DBA.
2. In the Password field, type sql.
3. In the Action dropdown list, select Connect to a running database on this computer.
4. In the Server Name field, type demo16.
Note

Since a computer system can run multiple SQL Anywhere database servers, always specify the database server name (ServerName=server-name) when connecting to a database.
Click Connect. Sybase Central connects to the database.

(Optional) Query the Customers table from Interactive SQL.

In the Interactive SQL window, type the following statement:

SELECT * FROM Customers;

Execute the statement. Press F5 or click SQL » Execute.

The result set appears in the Results pane.

Results

Sybase Central is started and connected to the sample database.

Next

Proceed to Lesson 3: Stopping the database server.