Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

UltraLite UID connection parameter

The user ID with which you connect to the database. The value must be an authenticated user for the database.

UID=id_name

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

You cannot set the UID to NULL or an empty string. Nor can the user ID exceed a maximum length of 31 characters.

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 in question and then add a new one.

The user ID is 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 semi-colons(;).

• Opening UltraLite connections with connection strings
• The role of user authentication
• Interpreting user ID and password combinations
• 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 AppForge: Authenticating users
• UltraLite for AppForge: Connecting to an UltraLite database
• UltraLite for AppForge: OpenConnection method
• 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

The following connection string fragment supplies the user ID DBA and password sql for a database called c:\MyOrders.udb:

"UID=DBA;PWD=sql"