Connect to an UltraLite database

UltraLite applications must connect to a database before carrying out operations on the data in it.

Here is the simplest way to establish a connection. Extensions to this technique are given in the following sections.

var DatabaseMgr;
var Connection;
DatabaseMgr = CreateObject("iAnywhere.UltraLite.DatabaseManager.CustDB");
Connection = DatabaseMgr.openConnection("dbf=" + DatabaseMgr.directory + "\\mydb.udb");

Using the Connection object

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

For more information about the Connection object, see Connection class [UltraLite for M-Business Anywhere].

Commit behavior By default, UltraLite applications are in autoCommit mode. Each insert, update, or delete statement is committed to the database immediately. Set Connection.autoCommit to false to build transactions into your application. Turning autoCommit off and performing commits directly can improve the performance of your application. See Connection.commit method [UltraLite for M-Business Anywhere].
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. See Connection.grantConnectTo method [UltraLite for M-Business Anywhere] and Connection.revokeConnectFrom method [UltraLite for M-Business Anywhere].
Synchronization A set of objects governing synchronization are accessed from the Connection object. See MobiLink data synchronization.
Tables UltraLite tables are accessed using the Connection.getTable method. See Connection.getTable method [UltraLite for M-Business Anywhere].

Discuss this page in DocCommentXchange.