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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Tutorial: Creating a SQL Anywhere Database

Lesson 1: Create a database file Next Page

Lesson 2: Connect to the database


In this lesson, you use Sybase Central to connect to the database file you created. However, if you just finished creating the database, you are already connected to it, and you can skip directly to the next lesson, where you learn to create tables. See Lesson 3: Create a table.

To connect to your database
  1. Start Sybase Central.

  2. From the Connections menu, choose Connect with SQL Anywhere 10.

    The Connect dialog appears.

  3. Specify the user ID and password.

    On the Identification tab, enter a User ID of DBA and a Password of sql. These are the default values for new databases.

  4. Select None in the profile options at the bottom of the tab.

  5. On the Database tab, type the full path of your database file in the Database File field. For example, if you followed the suggestion in the previous lesson, you should type the following:

    c:\temp\mysample.db
  6. Click OK.

    The database starts, and information about the database and the database server it is running on appear in Sybase Central.

    Sybase Central, connected to the mysample database.