Interpreting user ID and password combinations

UltraLite allows you to set one, none, or both of the UID and PWD parameters—except when a partial definition prevents a user from being identified by UltraLite. The table below tells you how UltraLite interprets incomplete user definitions.

If you create a database with... It has this impact...
No user ID or password. UltraLite creates a default user with a UID of DBA and PWD of sql. You do not need to supply these connection parameters upon future connection attempts.

The user ID parameter only.

UltraLite creates a default user with a UID of JaneD and an empty PWD. When connecting, you must always supply the UID parameter. The PWD parameter is not required.

The password parameter only.

UltraLite generates an error. UltraLite cannot set a password without a user ID.
 See also