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

• Opening UltraLite connections with connection strings
• UltraLite user authentication
• Interpreting user ID and password combinations
• UltraLite UID connection parameter
• UltraLite for C/C++: Authenticating users
• UltraLite for C/C++: Connecting to a database
• UltraLite for C/C++: OpenConnection function
• UltraLite for embedded SQL: Authenticating users
• UltraLite for embedded SQL: Connecting to a database
• UltraLite for M-Business Anywhere: Authenticating users
• UltraLite for M-Business Anywhere: Connecting to an UltraLite database
• UltraLite for M-Business Anywhere: openConnection method
• UltraLite.NET: Authenticating users
• UltraLite.NET: Connecting to a database
• UltraLite.NET: Open method

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=''"