UID=user

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

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

UltraLite user IDs are separate from MobiLink user names and from other SQL Anywhere user IDs. You cannot change a user ID once it is created. Instead, you must delete the user ID and then add a new one.

You cannot set the UID to NULL or an empty string. The maximum length for a user ID is 31 characters. User IDs are case insensitive.

Any leading or trailing spaces in parameter values are ignored. This connection parameter's value cannot include leading single quotes, leading double quotes, or semicolons.

• UltraLite connection strings and parameters
• UltraLite users
• 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 connection string fragment supplies the user ID DBA and password sql for a database:

"UID=DBA;PWD=sql"