User's Guide

Part II. Tutorials

Chapter 5. Using ISQL

When you start ISQL, it is not connected to any database. When a database is running, ISQL displays the SQL Anywhere Log On window.

1. You must enter a number of connection parameters in the Connection window.
   • User ID For the sample database, use the user ID dba.
   • Password The password for the dba user ID is sql.

     The password does not appear when you type it. This prevents someone else from seeing your password

   • The connect dialog contains a button labeled More>>. Click More>> to reveal a larger dialog box which contains more options for connecting to databases. These options are not needed for connecting to a database when only one database is running. (For the purposes of this tutorial, the options revealed by clicking More are not needed).
2. After entering the user ID and password, press enter (or click OK) to connect to the sample database.

If you have made typing mistakes or the sample database is not found, an error message appears. You can use the tab key to move to the field in error and correct the problem using the cursor keys and the backspace key.

After connecting to the database, ISQL displays the database name, user ID, and server name for the connection on the title bar.