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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » ODBC Configuration Dialog Help » SQL Anywhere ODBC driver

ODBC Configuration dialog: Login tab Next Page

ODBC Configuration dialog: Database tab


The Database tab of the ODBC Configuration dialog has the following components:

Server name    Type the name of the SQL Anywhere personal server or network server. For example, demo. 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 computer. If you do not have a default personal server and you omit the server name, the connection fails.

For more information about the server name, see Naming the server and the databases.

For more information, see EngineName connection parameter [ENG].

Start line    The start line is a command to start a personal database server or a network 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 server, for example to start the personal database server enter, c:\Program Files\SQL Anywhere 10\win32\dbeng10.exe.

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

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

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. This option is only necessary for starting a database that is not already running. You can click Browse to select the database file from the file directory.

For more information, see DatabaseFile connection parameter [DBF].

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.

For more information about encryption keys, 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.

Stop database after last disconnect    Select this option to automatically shut down the database after the last user disconnects.

For more information, see AutoStop connection parameter [ASTOP].