OLEDBConnection.MaintainConnection Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns True if the connection to the specified data source is maintained after the refresh operation and until the workbook is closed. Read/write Boolean.

public:
 property bool MaintainConnection { bool get(); void set(bool value); };

public bool MaintainConnection { get; set; }

Public Property MaintainConnection As Boolean

Property Value

Boolean

Boolean

Remarks

The default value is True. If you anticipate frequent queries to a server, setting this property to True might improve performance by reducing reconnection time. Setting this property to False causes an open connection to be closed.

Applies to

Share via