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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » SQL Anywhere database connections » Connection parameters

 

Resolving connection parameter conflicts

To resolve connection parameter conflicts:

  • Specify database files using DBF   Specify a database file in the StartLine (START) parameter or using the DatabaseFile (DBF) connection parameter (recommended).

  • Specify database names using DBN   Specify a database name in the StartLine (START) parameter, the DatabaseSwitches (DBS) connection parameter, or using the DatabaseName (DBN) connection parameter (recommended).

  • Specify database server names using ENG   Specify the name of the database server in the ServerName (ENG) parameter when you autostart a database file that is not already running. This ensures that the database connects to the intended database server.

  • Use the Start parameter to specify cache size   Use the StartLine (START) connection parameter to adjust the way the DatabaseFile (DBF) connection parameter starts a database file.

    For example, the following embedded database connection parameters start a database server with extra cache:

    DBF=samples-dir\demo.db
    DBN=Sample
    ENG=Sample Server
    UID=DBA
    PWD=sql
    START=dbeng11 -c 8M