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 » UltraLite Database Reference » UltraLite connection parameters

 

UltraLite PWD connection parameter

Defines the password for a user ID that is used for authentication.

Syntax
PWD=password
Default

If you do not set both the UID and PWD, UltraLite opens connections with UID=DBA and PWD=sql.

Remarks

You can set passwords to NULL or an empty string, but they cannot exceed the maximum length of 31 characters.

Every user of a database has a password. UltraLite supports up to four user ID/password combinations.

This connection parameter is not encrypted. However, UltraLite hashes the password before saving it, so you can only modify a password from Sybase Central.

See also
Examples

The following partial connection string supplies the user ID DBA and password sql:

"UID=DBA;PWD=sql"

The following partial connection string supplies the user ID DBA and an empty password:

"UID=DBA;PWD=''"