Contents Index Connecting to the sample database from Sybase Central or Interactive SQL Connecting to an embedded database

ASA Database Administration Guide
  Connecting to a Database
    Simple connection examples

Connecting to a database on your own machine from Sybase Central or Interactive SQL


The simplest connection scenario is when the database you want to connect to resides on your own machine. If this is the case for you, ask yourself the following questions:

The procedures below depend on your answers to these questions.

To connect to a database on an already-running local server

  1. Start Sybase Central or Interactive SQL and open the Connect dialog (if it doesn't appear automatically).

  2. On the Identification tab of the dialog, type a user ID and a password.

  3. Do one of the following:

To start and connect to a database

  1. Start Sybase Central or Interactive SQL and open the Connect dialog (if it doesn't appear automatically).

  2. On the Identification tab of the dialog, type a user ID and a password.

  3. Click the Database tab of the dialog.

  4. Specify a file in the Database File field (including the full path, name, and extension). You can search for a file by clicking Browse.

  5. If you want the database name for subsequent connections to be different from the file name, type a name in the Database Name field (without including a path or extension).

Tips 
If the database is already loaded (started) on the server, you only need to provide a database name for a successful connection. The database file is not necessary.

You can connect using a data source (a stored set of connection parameters) for either of the above scenarios by selecting the appropriate data source option at the bottom of the Identification tab of the Connect dialog.

For information about using data sources in conjunction with the JDBC driver (jConnect), see Specifying a driver for your connection.

See also


Contents Index Connecting to the sample database from Sybase Central or Interactive SQL Connecting to an embedded database