PWD=password

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

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

You can set passwords to NULL or an empty string.

A random 4-byte salt value is generated when a new user is created or an existing user changes their password. The salt value is appended to the user's password when calculating the password hash and is stored in the database along with the hash. Salting significantly decreases vulnerability to dictionary attacks and also ensures that users with the same password will have different password hashes.

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

• Users
• UltraLite connection strings and parameters
• UltraLite users
• UltraLite UID connection parameter
• UltraLite for C/C++: User authentication
• UltraLite for C/C++: Connecting to an UltraLite database
• ULDatabaseManager.OpenConnection method [UltraLite C++]
• UltraLite for embedded SQL: User authentication
• UltraLite for embedded SQL: Connect to an UltraLite database
• UltraLite for M-Business Anywhere: Connect to an UltraLite database
• DatabaseManager.openConnection method [UltraLite for M-Business Anywhere]
• UltraLite.NET: Connecting to an UltraLite database
• ULConnection.Open method [UltraLite.NET]

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