iAnywhere.com - Lesson 1: Start Interactive SQL

Lesson 1: Start Interactive SQL

In this section you start the Interactive SQL utility, connect to the sample database, and enter a command. We also test that the connection is working.

To start Interactive SQL and connect to the sample database (Windows)

Choose Start > Programs > SQL Anywhere 9 > Adaptive Server Anywhere > Interactive SQL.

The Connect dialog appears.
Click the ODBC Data Source Name option.
Click Browse, and select ASA 9.0 Sample from the list.
Click OK.
Click OK to connect to the sample database.

To connect to the sample database and start Interactive SQL (Command prompt)

If you are using Windows or UNIX operating systems, enter the following command to start the personal database server:
```
dbeng9 -n asademo9 asademo.db
```
Type the following command at a command prompt to start Interactive SQL and connect to the sample database:
```
dbisql -c "dsn=ASA 9.0 Sample"
```