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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » Using UltraLite Databases » Connecting to an UltraLite database » Introduction to UltraLite database connections » 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.

Examples:

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

Examples:

  • PWD=3saBys
  • UID=;PWD=3saBys
  • UID="";PWD=3saBys
UltraLite generates an error. UltraLite cannot set a password without a user ID.
See also