Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Connecting to an UltraLite Database » Introduction to UltraLite database connections » The role of user authentication

The role of user authentication Next Page

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

UltraLite creates a default user with a UID of DBA and PWD of sql. You do not need to supply these parameter upon future connection attempts.

The user ID parameter only.


  • UID=JaneD

  • UID=JaneD;PWD=

  • UID=JaneD;PWD=""

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.


  • PWD=3saBys

  • UID=;PWD=3saBys

  • UID="";PWD=3saBys

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

See also