|
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.