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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » SQL Anywhere database connections » Sample SQL Anywhere database connections

 

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 already-running on a local server
  1. Start Sybase Central or Interactive SQL.

    If the Connect window does not appear:

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

    • In Interactive SQL, choose SQL » Connect.

  2. Click the Identification tab.

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

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

  5. If the server is running a single database, click OK.

    If the server is running multiple databases:

    • Click the Database tab.

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

    • Click OK.

To start and connect to a database
  1. Start Sybase Central or Interactive SQL.

    If the Connect window does not appear:

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

    • In Interactive SQL, choose SQL » Connect.

  2. Click the Identification tab.

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

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

  5. Click the Database tab.

  6. In the Database File field, specify the file path, file name, and file extension, or click Browse to browse for a database file.

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