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 - Database Administration » Connecting to a Database » Simple connection examples

Simple connection examples Next Page

Connecting to the sample database from Sybase Central or Interactive SQL

Many examples and exercises throughout the documentation start by connecting to the sample database from Sybase Central or Interactive SQL.

To connect to the sample database (Sybase Central)

  1. Start Sybase Central: from the Start menu, choose Programs > SQL Anywhere 10 > Sybase Central.

  2. Open the Connect dialog: choose Connections > Connect with SQL Anywhere 10.

  3. Select the ODBC Data Source Name option and click Browse.

  4. Select SQL Anywhere 10 Demo and then click OK.

To connect to the sample database (Interactive SQL)

  1. Start Interactive SQL: from the Start menu, choose Programs > Sybase > SQL Anywhere 10 > Interactive SQL.

  2. Open the Connect dialog: from the SQL menu, choose Connect.

  3. Select the ODBC Data Source Name option and click Browse.

  4. Select SQL Anywhere 10 Demo and then click OK.

    The database name, user ID, and server name appear in the title bar above the SQL Statements pane.

Note

You do not need to enter a user ID and a password for this connection because the data source already contains this information.

To connect to the sample database (specifying the database file location)

  1. In Sybase Central or Interactive SQL, open the Connect dialog.

  2. On the Identification tab, type the following values:

  3. On the Database tab, type or browse to the location of the sample database file, demo.db. By default, this file is located in samples-dir. For example, on Windows XP the default location is C:\Documents and Settings\All Users\Documents\SQL Anywhere 10\Samples\demo.db.

    For information about samples-dir, see Samples directory.

  4. Click OK.