UltraLite ActiveX User's Guide
Understanding UltraLite ActiveX Development
Your UltraLite application must connect to a database before it can carry out operations on the data in the database.
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.
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