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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Connecting to an UltraLite Database

Specifying file paths in an UltraLite connection parameter Next Page

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 repeatedly supply the same connection parameters during development to UltraLite administration tools. 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 in UltraLite. All platforms supported by UltraLite allow you to use = inside an environment variable setting.

To set ULSQLCONNECT for UltraLite desktop tools
  1. At the command prompt, enter the following:

    set ULSQLCONNECT="parameter=value; ..."

  2. If an administration tool requires any additional parameter 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 variable.

  3. See also

    To use ULSQLCONNECT to connect to a file named c:\database\myfile.udb connecting as a user called demo and a password of test, set the following variable in your environment:

    set ULSQLCONNECT="DBF=c:\database\myfile.udb;UID=demo;PWD=test"

    By setting this environment variable, you no longer need to use the -c connection option for these defaults values—unless you need to override these values.

    For example, if you were using ulload to add additional information to your database from an extra.xml file, you would simply run the command as follows:

    ulload -a extra.xml