Connecting to the sample database (Sybase Central)

Connect to the sample database to explore SQL Anywhere and try out many of the examples found throughout the documentation.

Prérequis

Linux You must have a version of Linux that supports the Linux Applications menu. The menu items must be installed as part of the SQL Anywhere installation.
Unix The SQL Anywhere utilities must already be sourced. See Unix and Mac OS X environment variables.
Mac OS X The SQL Anywhere utilities must already be sourced. See Unix and Mac OS X environment variables.

Contexte et remarques

Sybase Central is a graphical tool that can be used as an alternative to using SQL statements and command line utilities for managing your database servers, databases, and the objects they contain.

This procedure does not apply to Windows Mobile.

Task

Open Sybase Central by clicking Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

Note

Mac OS X In the Finder, double-click Sybase Central in /Applications/SQLAnywhere16.

Unix In a terminal session, run the following command:

scjview

Linux Click Applications » SQL Anywhere 16 » Administration Tools » Sybase Central.

Click Connections » Connect with SQL Anywhere 16.
In the Action dropdown list, click Connect with an ODBC Data Source.
Click ODBC Data Source name, and then type SQL Anywhere 16 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 16 Demo data source already contains this information.
  
  In a production environment, you should not store passwords in an ODBC data source.
- The database server does not need to be running before connecting since the SQL Anywhere 16 Demo data source automatically starts the database server.
(Optional) To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.
Click Connect.

Résultat

The database server and database start and Sybase Central connects to the sample database.