UltraLite Database User's Guide
Connection Parameters
User authentication parameters
The user ID with which you log on to the database. An authenticated user for the database. User ID's are case-insensitive if the database is case-insensitive and case sensitive if the database is case sensitive.
Databases are created with a single authenticated user DBA whose initial password is SQL. By default, connections are opened using the UID=DBA and the PWD=SQL. To disable the default user, use
connection.revokeConnectionFrom.
To add a user or change a user's password, use
connection.grantConnectTo.
| Interface | Connection parameter |
|---|---|
| UltraLite for MobileVB | UserID |
| UltraLite ActiveX | UserID |
| UltraLite.NET | UserID |
| Native UltraLite for Java | userID |
| Connection string | { userid | UID } |
For information about using the connection parameter, see Specifying connection parameters.
Anywhere
String
DBA
You must always supply a user ID when connecting to a database, unless you leave the database using the default user ID and password of DBA and SQL.
The following connection string fragment supplies the user ID DBA and password SQL:
"schema_file=MyOrders.usm;uid=DBA;pwd=SQL"