Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database connections


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.


There are no prerequisites for this task.

  1. Open the Connect window in Sybase Central or Interactive SQL.

  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:\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.


      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.

  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.


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

 See also