Data.Win.ADODB.TADOConnection.KeepConnection
Delphi
property KeepConnection: Boolean read FKeepConnection write SetKeepConnection default True;
C++
__property bool KeepConnection = {read=FKeepConnection, write=SetKeepConnection, default=1};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | Data.Win.ADODB.pas Data.Win.ADODB.hpp |
Data.Win.ADODB | TADOConnection |
Description
Specifies whether an application remains connected to a database even if no datasets are open.
Use KeepConnection to specify whether an application remains connected to a database even if no associated dataset components are currently active. 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.