Starting and connecting to a database on this computer (dbeng12)

To start a server and database, and then connect to this 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

None.

Context and remarks

Many.

 Start and connect to a database (command line)
  • Run the following command to start Interactive SQL and start and connect to the sample database:

    dbisql -c "UID=DBA;PWD=sql;ServerName=Demo12;DBF=%SQLANYSAMP12%\demo.db"
 Starting and connecting to a database on this computer (dbeng12)
  1. Open the Connect window in Sybase Central or Interactive SQL. See Opening the Connect window (Sybase Central).

  2. 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:\Documents and Settings\All Users\Documents\SQL Anywhere 12\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 server. For example, type demo12.

      Note

      Your computer may be running software that has an embedded SQL Anywhere server, in which case there could be multiple servers running without you realizing it. You should always specify the server name (ServerName=server-name).

  3. Optional: To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.

  4. Click Connect.

Results

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

Next

None.

 See also