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

SQL Anywhere 11.0.0 » Context-Sensitive Help » Connect window help


Connect window: Database tab (SQL Anywhere)

This tab has the following components:

Server name   Type the name of the SQL Anywhere personal database or network database server. For example, demo. You must supply a database server name if you want to connect to a network server. You can omit the database server name if you want to connect to the default personal server.

You can choose a recently-used database server name from the dropdown list or click Find to search for a server. When you click Find, a window appears listing running local personal servers and network servers. To choose a database server from this window, select a database server from the list, and then click OK. The database server name appears on the Database tab in the Server Name field. See Naming the server and the databases.

The Server Name connection parameter is a synonym for the EngineName (ENG) connection parameter. See ServerName connection parameter [ENG].

Start line   A start line is a command to start a personal or a network database server on your computer. Enter a start line only if you want to connect to a local database server that is not currently running and if you want to set your own start parameters. You must enter the full path of the database server; for example to start the personal database server, enter c:\Program Files\SQL Anywhere 11\Bin32\dbeng11.exe. Alternatively, you can choose a recently used start line from the dropdown list. See StartLine connection parameter [START].

You can also include options in the Start Line field. The start line and options are used when you want to:

  • Employ any advanced server features.
  • Control protocol options.
  • Provide diagnostic or troubleshooting messages.
  • Set permissions.
  • Set database parameters (including encryption).

For more information about options you can specify in the Start Line field, see:

Search network for database servers   Select this option if you want to connect to a database server that is running on a computer other than your local computer. You should clear this option if you want to connect to a database server on your local computer. Selecting this option adds the LINKS=ALL connection parameter to the connection string. See Connection parameters.

Database name   Each database running on a database server is identified by a database name. Type the name of the database you are connecting to.

You need a database name only if there is more than one database running on the database server. If the database is not already running on the server, you should specify the database file instead.

You can also choose a recently-used database name from the dropdown list or click Browse to locate the database file.

For more information about the database name, see:

Database file   Specify the database file when the database you want to connect to is not currently running on a database server. It is recommended that you type the full path and name of the database file, for example, C:\sample.db. Otherwise, the path of the file is relative to the working directory of the database server.

You can also choose a recently-used database file from the dropdown list or click Browse to search for the database file. See DatabaseFile connection parameter [DBF].


If you specify both the database name and database file when trying to connect to a database that is already running, the database file is ignored.

  • Encryption key   If the database file is encrypted, you must supply a key to the database server every time the database server starts the database.

    The Encryption key field is enabled only after you fill in the Database File field. You can also supply encryption options in the Start Line field. See DatabaseKey connection parameter [DBKEY].

Start database automatically   Select this option to start the database specified in the Database File field before you connect to it.

You should clear the Start Database Automatically option if you want to ensure that you connect only to a running database. See AutoStart connection parameter [ASTART].

Stop database after last disconnect   Select this option to automatically shut down the database after the last user disconnects. See AutoStop connection parameter [ASTOP].

See also