Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Tutorial: Connecting to the sample database


Lesson 2: Connecting to the database

Connect to the sample database by using Sybase Central.


This lesson assumes that you have completed all preceding lessons. See Lesson 1: Starting the SQL Anywhere database server and displaying the database server messages window.

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.

  1. Start Sybase Central. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

  2. Click Connections » Connect With SQL Anywhere 16.

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


    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.

  4. Click Connect. Sybase Central connects to the database.

  5. (Optional) Query the Customers table from Interactive SQL.

    1. Open Interactive SQL. In Sybase Central, click File » Open Interactive SQL.

    2. In the Interactive SQL window, type the following statement:

      SELECT * FROM Customers;
    3. Execute the statement. Press F5 or click SQL » Execute.

      The result set appears in the Results pane.


Sybase Central is started and connected to the sample database.

 See also