iAnywhere.com - Connecting to an UltraLite database

Understanding UltraLite ActiveX Development

Connecting to an UltraLite database

UltraLite applications must connect to a database before carrying out operations on the data in it. This section describes how to connect to an UltraLite database.

Using the ULConnection object

The following properties of the ULConnection object govern global application behavior.

For more information about the ULConnection object, see ULConnection class.

Commit behavior By default, UltraLite applications are in AutoCommit mode. Each insert, update, or delete statement is committed to the database immediately. Set ULConnection.AutoCommit to false to build transactions into your application. Turning AutoCommit off and performing commits directly can improve the performance of your application.
For more information, see Commit method.
User authentication You can change the user ID and password for the application from the default values of DBA and SQL by using the GrantConnectTo and RevokeConnectFrom methods.
For more information, see User authentication.
Synchronization A set of objects governing synchronization are accessed from the ULConnection object.
For more information, see Synchronizing UltraLite applications.
Tables UltraLite tables are accessed using the ULConnection.GetTable method.
For more information, see GetTable method.

Connecting to a database

You can connect to a database using either a ULConnectionParms object or a connection string. Methods that use a ULConnectionParms object allow you to manipulate connection parameters with ease and accuracy. Methods that use a connection string require that you successfully create a connections string.

The following sections describe both methods.

Using ULConnectionParms to connect to a database
Using a connection string to connect to a database