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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » Using UltraLite databases » Connecting to an UltraLite database


Storing UltraLite parameters with the ULSQLCONNECT environment variable

The ULSQLCONNECT environment variable is optional, and is not set by the installation program. ULSQLCONNECT contains a list of parameters defined as keyword=value pairs in a semicolon delimited list.

Use ULSQLCONNECT to avoid having to supply the same connection parameters repeatedly to dbisql during development. You cannot use ULSQLCONNECT for custom applications.


Do not use the pound character (#) as an alternative to the equal sign; the pound character is ignored by dbisql. All platforms supported by UltraLite allow you to use = inside an environment variable setting.

 To set ULSQLCONNECT for UltraLite desktop tools
  1. Run the following command:

    set ULSQLCONNECT="parameter=value; ..."
  2. If dbisql requires any additional parameters or if you need to override default values set with this environment variable, ensure you set these values. User supplied values always take precedence over this environment variable.

 See also