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

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:

• Is the database already running on a server? If so, you can specify fewer parameters in the Connect dialog. If not, you need to identify the database file so that Sybase Central or Interactive SQL can start it for you.

• Are there multiple databases running on your machine? If so, you need to identify the database to which you want Sybase Central or Interactive SQL to connect. If there is only one database, Sybase Central or Interactive SQL assumes that you want to connect to that one, and you don't need to specify it in the Connect dialog.

The procedures below depend on your answers to the questions.

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, enter a user ID and a password.

3. Do one of the following:

   • If the server only contains the one database, click OK to connect to it.

   • If the server contains multiple databases, click the Database tab of the dialog and specify a database name. This is usually the database file name, without the path or extension.

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

2. Open the Identification tab of the dialog, enter 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, enter a name in the Database Name field (without including a path or extension).

See also