Prompt the end user at connection time when you require a user to authenticate as one of the four supported database users. The UltraLite graphical administration tools use a connection object.

You can use the UltraLite.Net ULConnectionParms object or the UltraLite for M-Business Anywhere ConnectionParms object to aid connection parameter collection and inspection. See:

• UltraLite.NET: ULConnectionParms class and
• UltraLite for M-Business Anywhere: ConnectionParms class

Use a fixed connection string if user authentication is not required. Common reasons for not authenticating a user may be because the deployment is to a single-user device, or that it is too awkward to prompt a user each time they start the application. The UltraLite command line utilities typically use a connection string if a connection to a database is required. You can also program your UltraLite application to read the values from a stored file, or hard code it into your application. See:

• UltraLite.NET: Connecting to a database
• UltraLite C/C++ : Connecting to a database
• UltraLite for M-Business Anywhere: Connecting to an UltraLite database
• UltraLite for embedded SQL: Connecting to a database

dbisql is the only tool that supports ULSQLCONNECT. Use the ULSQLCONNECT environment variable if you want to store connection parameters you use repeatedly. By storing parameters, you don't need to provide them repeatedly during the development phase. Values you supply as a parameter in ULSQLCONNECT become defaults for the UltraLite desktop administration tools.