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 11 » Sybase Central.

  2. Open the Connect window: choose Connections » Connect With SQL Anywhere 11.

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

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

To connect to the sample database (Interactive SQL)

  1. Start Interactive SQL: from the Start menu, choose Programs » SQL Anywhere 11 » Interactive SQL.

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

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

  4. Select SQL Anywhere 11 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 window.

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

    • User ID   Type DBA.

    • Password   Type sql.

  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 11\Samples\demo.db.

    For information about samples-dir, see Samples directory.

  4. Click OK.

Connecting to the sample database on Mac OS X

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0