UltraLite connection parameters and the ULSQLCONNECT environment variable

Use the ULSQLCONNECT environment variable to avoid having to supply the same connection parameters repeatedly to Interactive SQL during development. Interactive SQL is the only tool that supports the ULSQLCONNECT environment variable; you cannot use the variable for custom applications.

The ULSQLCONNECT environment variable is optional, and is not specified by default. You can set the ULSQLCONNECT environment variable to contain a list of parameters defined as keyword=value pairs in a semicolon delimited list.

The supplied values become defaults for the UltraLite desktop administration tools. If Interactive SQL 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.

Caution

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.

Example

In this example, you use the ULSQLCONNECT environment variable to connect to a file named c:\database\myfile.udb and authenticate the user demo with the password test.

Set the following variable in your ULSQLCONNECT environment variable:

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

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

Discuss this page in DocCommentXchange.