SQL Anywhere Studio Help
Connect Dialog Help
The Database tab of the Connect dialog has the following components:
Server name Type the name of the Adaptive Server Anywhere or network server. For example, asademo. You need to supply a server name if you want to connect to a network server.
Do not enter a Server Name if you want to connect to the default local personal server or if you want to start a database server from a database file on your local machine. If you do not have a default personal server and you omit the server name, the connection fails.
You can select a recently-used server name from the dropdown list or click Find to search for a server. When you click Find, a dialog appears listing running local personal servers and network servers. To choose a server from this dialog, select a server from the list and then click OK. The server name appears on the Database tab in the Server Name field.
For more information about the server name, see Naming the server and the databases.
Start line The start line is a command to start a personal database server or a network server on your machine. 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 server, for example to start the personal database server enter, c:\Program Files\Sybase\SQL Anywhere 9\win32\dbeng9.exe. Alternatively, you can select a recently used start line from the dropdown list.
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 communications parameters.
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 Some common options and The database server.
Search network for database servers Select this option if you want to connect to a server that is running on a machine other than your local machine. You should clear this option if you want to connect to a database server on your local machine.
Database name Each database running on a 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 server. If the database is not already running on the server, you should specify the database file instead.
You can also select 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 Naming the server and the databases and DatabaseName connection parameter [DBN].
Database file Specify the database file when the database you want to connect to is not currently running on a 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 server.
You can also select a recently-used database file from the dropdown list or click Browse to search for the database file.
NoteIf 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. If the database is strongly encrypted using AES or MDSR, you must specify a key in this field to access the database.
You can also supply encryption options in the Start Line field.
For more information about encryption keys, see Encryption Key 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.
Stop database after last disconnect Select this option to automatically shut down the database after the last user disconnects.
Troubleshooting server startup
Troubleshooting network communications