UltraLite ActiveX User's Guide
UltraLite ActiveX API Reference
ULConnectionParms class
The ULConnectionParms class specifies parameters for opening a connection to an UltraLite database.
In UltraLite ActiveX, you can use the ULConnectionParms object and set your connection properties in your code. You use the ULConnectionParms object in conjunction with the 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 String (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. |
| 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:
|
| 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. |
| 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. |