Connecting to the sample database (Sybase Central)

Many of the examples throughout the documentation use the SQL Anywhere sample database. Connect to this database and explore SQL Anywhere features.

Prerequisites

None.

Context and remarks

Many.

Start Sybase Central or Interactive SQL, and then open the Connect window.
1. If the Connect window does not appear:
  - In Sybase Central, click Connections » Connect With SQL Anywhere 12.
  - In Interactive SQL, click SQL » Connect.
2. If you are in Interactive SQL and the database type is not SQL Anywhere, click Change Database Type, and then click SQL Anywhere.
In the Action dropdown list, click Connect With An ODBC Data Source.
Click ODBC Data Source Name, and then type SQL Anywhere 12 Demo in the field below.
Note
- You do not need to enter a user ID and a password for this connection because the SQL Anywhere 12 Demo data source already contains this information.
  
  In a production environment, it is recommended that you do not store passwords in an ODBC data source. See Do not include passwords in ODBC data sources.
- The database server does not need to be running before connecting since the SQL Anywhere 12 Demo data source contains enough information to automatically start the database server. See SQL Anywhere sample database.
Optional: To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.
Click Connect.

Results

The database server and database start and Interactive SQL or Sybase Central connects to the database.

Next

None.