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
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1