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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database connections » UltraLite connection strings and parameters

Precedence of connection parameters for UltraLite administration tools

UltraLite administration tools follow a specific order of connection parameter precedence:

  • Device-specific options take precedence over nonspecific options. For example: device:DBF takes precedence over DBF on Windows Mobile devices.

  • Desktop-specific options take precedence over nonspecific options. For example: desktop:DBF takes precedence over DBF on Windows.

  • If you supply duplicate parameters in a connection string, the last one supplied is used. All others are ignored.

  • Parameters in the connection string take precedence over those supplied in the ULSQLCONNECT environment variable or a connection object.

  • If no value is supplied for both UID and PWD in either the connection string or ULSQLCONNECT, the defaults of UID=DBA and PWD=sql are assumed.