UltraLite for MobileVB User's Guide
UltraLite for MobileVB API Reference
ULConnectionParms class
The ULConnectionParms class specifies parameters for opening a connection to an UltraLite database.
In UltraLite for MobileVB, ensure you have the ULConnectionParms object on your form and you set connection properties in the ConnectionParms dialog. You use the ULConnectionParms object in conjunction with ULDatabaseManager.CreateDatabaseWithParms and ULDatabaseManager.OpenConnectionWithParms methods.
NoteDatabases are created with a single authenticated user, DBA, whose initial password is SQL. By default, connections are opened using the user ID DBA and password SQL. |
For more information about the meaning of these parameters, see Connection Parameters.
| Prototype | Description |
|---|---|
| AdditionalParms As String (read-write) | Additional parameters specified as name=value pairs separated with semi-colons. |
| CacheSize As Integer (read-write) | The size of the cache. CacheSize values are specified in bytes. Use the suffix k or K for kilobytes and use the suffix m or M for megabytes. The default cache size is sixteen pages. Given a default page size of 4 KB, the default cache size is 64 KB. |
| ConnectionName As String (read-write) | A name for the connection. This is needed only if you create more than one connection to the database. |
| DatabaseOnCE As String (read-write) | The filename of the database deployed to PocketPC. |
| DatabaseOnDesktop As String (read-write) | The filename of the database during development. |
| DatabaseOnPalm As String (read-write) | The UltraLite database on the Palm device. |
| EncryptionKey As String (read-write) |
A key for encrypting the database. OpenConnection and OpenConnectionWithParms must use the same key as specified during database creation. Suggestions for keys are:
|
| PageSize As Integer (read-write) | The page size for the database. |
| ParmsUsed As String (read-only) | The parameters used by the ULDatabaseManager. Useful for debugging purposes. |
| Password As String (read-write) | The password for an authenticated user. Databases are initially created with one authenticated user password SQL. Passwords are case-insensitive if the database is case-insensitive and case-sensitive if the database is case-sensitive. The default value is SQL. |
| ReserveSize As Integer (read-write) | The amount of file system space to reserve for storage of UltraLite persistent data. |
| SchemaOnCE As String (read-write) | The schema filename deployed to PocketPC. |
| SchemaOnDesktop As String (read-write) | The schema filename during development. |
| SchemaOnPalm As String (read-write) | The schema PDB on the Palm device. |
| UserID As String (read-write) | The authenticated user for the database. Databases are initially created with one authenticated user DBA. The UserID is case-insensitive if the database is case-insensitive and case-sensitive if the database is case-sensitive. The default value is DBA. |
| VFSOnPalm As Boolean (read-write) | Indicates whether the Palm database is on a virtual file system (true) or on the Palm store (false). |