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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » Using UltraLite Databases » Connecting to an UltraLite database » UltraLite user authentication


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 connection parameters 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