EPUB | CHM | PDF

TPSQLDatabase.Properties.KeepConnection

Top Previous Next

Specifies whether an application remains connected to a database even if no datasets are open.

Syntax:

property KeepConnection: Boolean;

Description:

Use KeepConnection to specify whether an application remains connected to a database even if no datasets are currently open. When KeepConnection is True (the default) the connection is maintained. For connections to remote database servers, or for applications that frequently open and close datasets, set KeepConnection to True to reduce network traffic, speed up applications, and avoid logging in to the server each time the connection is reestablished.

When KeepConnection is False a connection is dropped when there are no open datasets. Dropping a connection releases system resources allocated to the connection, but if a dataset is later opened that uses the database, the connection must be reestablished and initialized.