Connect to the sample database from Sybase Central or Interactive SQL

 To connect to the sample database (Sybase Central)
  1. Choose Start » Programs » SQL Anywhere 12 » Administration Tools » Sybase Central.

  2. Click Connections » Connect With SQL Anywhere 12.

  3. From the Action dropdown list choose Connect With An ODBC Data Source.

  4. Click ODBC Data Source Name, and then type in the box below, SQL Anywhere 12 Demo.

  5. Click Connect.

 To connect to the sample database (Interactive SQL)
  1. Choose Start » Programs » SQL Anywhere 12 » Administration Tools » Interactive SQL.

  2. Click Change Database Type and choose SQL Anywhere.

  3. From the Action dropdown list choose Connect With An ODBC Data Source

  4. Click ODBC Data Source Name, and then type in the box below, SQL Anywhere 12 Demo.

  5. Click Connect.

Note

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

However, in a production environment, it is recommended that you do not store passwords in the ODBC Data Source. See Do not include passwords in ODBC data sources.

 To connect to the sample database (specifying the database file location)
  1. In Sybase Central or Interactive SQL, open the Connect window. See Open the Connect window.

  2. From the Authentication dropdown list, choose Database.

  3. In the User ID field, type DBA.

  4. In the Password field, type sql.

  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. In the Database File field, browse to samples-dir. On Microsoft Windows XP operating systems the default location is C:\Documents and Settings\All Users\Shared Documents\SQL Anywhere 12\Samples\demo.db.

    For information about samples-dir, see Samples directory.

  7. In the Database Name field, type demo.db.

  8. Click Connect.

 See also