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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database connections

Alphabetical list of connection parameters

Connection parameters are included in connection strings.

They can be entered in the following places:

  • In an application's connection string.

  • SQLConnect environment variable.

  • In an ODBC data source.

  • In the SQL Anywhere Connect window.

  • Connection parameters are case insensitive, although their values may not be (for example, file names on Unix).

  • Boolean parameters are turned on with YES, Y, ON, TRUE, T, or 1, and are turned off with any of NO, N, OFF, FALSE, F, and 0. The parameter values are case insensitive (for example, YES, Yes, yes. etc. are equivalent).

  • The Usage for each connection parameter describes the circumstances under which the parameter is to be used. Common usage entries include the following:

    • Embedded databases

      The personal database server (dbeng17) is typically used with embedded applications. When the application disconnects from the database, the database is unloaded and the server stops.

    • Local database servers

      A local database server refers to a server running on your personal computer. You can use either the personal server (dbeng17) or the network server (dbsrv17).

    • Network database servers

      A network server (dbsrv17) can be run on your personal computer or on another computer on a network. Use the network server when you want others to be able to connect to the database.

  • You can use the dbping utility to test connection strings. The -c option is used to specify the connection parameters. For example, suppose a database server with the name demo17 is running the sample database (which can be started with the command dbsrv17 -n demo17 "%SQLANYSAMP17%\demo.db"). The following command returns a message indicating that the connection to the database was successful.

    dbping -d -c "Server=demo17;DBN=demo;UID=DBA;PWD=sql"

    The following command returns the message Ping server failed - Database server not found if no database server named other-server is running on the local computer:

    dbping -c "Server=other-server"