Many of the examples throughout the documentation use the SQL Anywhere sample database. Connect to this database and explore SQL Anywhere.
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:
In a terminal window, start Interactive SQL:
The Connect window appears by default.
Provide the following information in the Connect window:
In the User ID field, type DBA.
In the Password field, type sql.
In the Action dropdown list, click Connect to a running database on this computer.
In the Server name field, type demo.
Optional: To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|