Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database connections

 

Connecting to the sample database on Unix

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

Prérequis

The following procedure uses Interactive SQL to connect to the database. Ensure that the Java Runtime Environment (JRE) is installed.

In a typical Unix installation, the SQL Anywhere software, including the sample database, is installed into a directory that you do not have permissions to write to. Before you begin, in a terminal window, change to a writable folder. Run the following command to copy the sample database file into the folder:

cp "samples-dir/demo.db" .

In a terminal window, run the following command to start the sample database on a database server:

dbeng16 demo.db
 Task
  1. In a terminal window, start Interactive SQL:

    dbisql

    The Connect window appears by default.

  2. Provide the following information in the Connect window:

    1. In the User ID field, type DBA.

    2. In the Password field, type sql.

    3. In the Action dropdown list, click Connect to a running database on this computer.

    4. In the Server name field, type demo.

    5. Optional: To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.

    6. Click Connect.

Résultat

Interactive SQL starts and connects to the sample database.

 See also