Connect to a local database

Use one of the following procedures to connect to a database residing on your computer. If the database is already loaded (started) on the server, only the database name is required to connect to the database. You do not need to specify a database file.

To simplify database access, use a connection profile. See Sybase Central connection profiles.

 To connect to a database that is already running on a local server (Sybase Central and Interactive SQL)

  1. Start Sybase Central or Interactive SQL.

    If the Connect window does not appear:

    • In Sybase Central, choose Connections » Connect With SQL Anywhere 12.

    • In Interactive SQL, choose SQL » Connect.

      Click Change Database Type, and then choose SQL Anywhere.

  2. From the Authentication dropdown list, choose Database.

  3. In the User ID field, type a user name.

  4. In the Password field, type a password for the database.

  5. From the Action dropdown list, choose Connect To A Database On This Computer to connect to a database that is running on your computer.

  6. If the server is running a single database, click Connect.

    If the server is running multiple databases:

    • In the Database Name field, type the name of the database.

    • Click Connect.

 To start and connect to a database (Sybase Central and Interactive SQL)

  1. Start Sybase Central or Interactive SQL.

    If the Connect window does not appear:

    • In Sybase Central, choose Connections » Connect With SQL Anywhere 12.

    • In Interactive SQL, choose SQL » Connect.

    • Click Change Database Type, and then choose SQL Anywhere.

  2. From the Authentication dropdown list, choose Database.

  3. In the User ID field, type a user name.

  4. In the Password field, type a password for the database.

  5. From the Action dropdown list, choose Start And Connect To A Database On This Computer to start and connect to a database on your computer.

  6. In the Database File field, specify the file path, file name, and file extension.

  7. To create a database name that is different from the file name for subsequent connections, type a name in the Database Name field. Do not specify a file path or extension.

  8. Click Connect.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0