INFO: OLEDB session pooling supports limit on connection lifetime (301384)


The information in this article applies to:

  • Microsoft Data Access Components 2.8
  • Microsoft Data Access Components 2.7
  • Microsoft Data Access Components 2.7 SP1
This article was previously published under Q301384

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.

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.
Modification Type:MajorLast Reviewed:8/25/2004
Keywords:kbinfo KB301384 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.