Starting and connecting to a database on a local computer (Sybase Central or Interactive SQL)

To start a database server and database, and then connect to the local database all from the same computer, you can use the Connect window with the Start and connect to a database on this computer option.

Prerequisites

There are no prerequisites for this task.

Task

Open the Connect window in Sybase Central or Interactive SQL.
Complete the following fields to connect to the database:
1. In the Authentication dropdown list, click Database.
2. In the User ID field, type a user name. For example, type DBA.
3. In the Password field, type the password for the user. For example, type sql.
4. In the Action dropdown list, click Start and connect to a database on this computer.
5. In the Database file field, specify the database file path, file name, and file extension. For example, type C:\Users\Public\Documents\SQL Anywhere 16\Samples\demo.db;.
6. To create a database name that is different from the file name for subsequent connections, type a name in the Database name field. Do not specify a file path or extension.
7. In the Server name field, specify a name for the database server. For example, type demo16.
  
  Note
  
  Since a computer system can run multiple SQL Anywhere database servers, always specify the database server name (ServerName=server-name) when connecting to a database.
Optional: To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.
Click Connect.

Results

The database server and database start and the administration tool connects to the database.

Starting and connecting to a database on a local computer (Sybase Central or Interactive SQL)

Task

Note

See also