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

SQL Anywhere 10.0.1 » UltraLite - AppForge Programming » UltraLite for AppForge API Reference » ULConnectionParms class

ULConnectionParms class Next Page


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.CreateDatabase and ULDatabaseManager.OpenConnection methods.


Databases are created with a single authenticated user, DBA, whose initial password is sql. If a user ID and password are not supplied, connections are opened using the user ID DBA and password sql.

For more information about the meaning of these parameters, see UltraLite Connection String Parameters Reference.



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.

See UltraLite CACHE_SIZE connection parameter.

ConnectionName As String (read-write)

A name for the connection. This is needed only if you create more than one connection to the database.

See UltraLite CON connection parameter.

DatabaseOnCE As String (read-write)

The file name of the database deployed to Windows CE.

See UltraLite CE_FILE connection parameter.

DatabaseOnDesktop As String (read-write)

The file name of the database during development.

See UltraLite DBF connection parameter.

DatabaseOnPalm As String (read-write)

The creator ID for the UltraLite database on the Palm device.

See UltraLite PALM_FILE connection parameter.

DatabaseOnSymbian As String (read-write)

The file name of the database on Symbian OS device.

See UltraLite SYMBIAN_FILE connection parameter.

EncryptionKey As String (read-write)

A key for encrypting the database. OpenConnection must use the same key as specified during database creation. Recommended guidelines for keys are:

  1. Select an arbitrary, lengthy string

  2. Select strings with a variety of numbers, letters and special characters, to decrease the chances of successfully guessing the key.

See UltraLite DBKEY connection parameter.

PalmCreatorID As String (read-write)

A registered four digit Palm creator ID.

Password As String (read-write)

The password for an authenticated user. Databases are initially created with one authenticated user (DBA) with password sql. Passwords are case sensitive.

See UltraLite PWD connection parameter.

ToString As StringThe connection string, as built from the current property settings.

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.

See UltraLite UID connection parameter.