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 parameters and the ULSQLCONNECT environment variable

Use the ULSQLCONNECT environment variable to avoid having to supply the same connection parameters repeatedly to the UltraLite desktop administration tools. Both Interactive SQL and SQL Central support the ULSQLCONNECT environment variable.

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 desktop administration tools. If any additional parameters are required or if you must override default values set with this environment variable, ensure that you set these values. User-supplied values always take precedence over this environment variable.


In this example, you set the ULSQLCONNECT environment variable to specify a default database file named c:\database\myfile.udb, a default user demo, and a default password test.

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

If you launch Interactive SQL with no arguments, then you will automatically connect to the specified database using the specified credentials. If you launch SQL Central and connect to an UltraLite database, these parameters are used to populate the connection dialog.