Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

INFO: OLEDB session pooling supports limit on connection lifetime


View products that this article applies to.

This article was previously published under Q301384

↑ Back to the top


Summary

Starting with MDAC 2.7, the OLE DB Service Components support a limit on the lifetime of a pooled connection.

WIth this feature, you can add load balanced servers "on the fly." When a new server is added, the system will gradually balance connections out to the new server as the old connections expire.

↑ Back to the top


More information

The default connection lifetime limit is 600 seconds (10 minutes). To change this limit:
  1. Locate the following registry key:
    HKEY_CLASSES_ROOT\CLSID\{2206CDB0-19C1-11D1-89E0-00C04FD7A829}
    Note This is the CLSID for the MSDAINIT object.
  2. Set the MaxResLifeTime DWORD value to the lifetime that you want, in seconds.

    Note If the DWORD value of the MaxResLifeTime entry is set to �fffffffff� then a pooled connection is not configured.

↑ Back to the top


Keywords: KB301384, kbinfo

↑ Back to the top

Article Info
Article ID : 301384
Revision : 6
Created on : 8/25/2004
Published on : 8/25/2004
Exists online : False
Views : 423