Microsoft KB Archive/301384

= INFO: OLEDB session pooling supports limit on connection lifetime =

Article ID: 301384

Article Last Modified on 8/25/2004

-

APPLIES TO


 * Microsoft Data Access Components 2.8
 * Microsoft Data Access Components 2.7
 * Microsoft Data Access Components 2.7 Service Pack 1

-



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 &quot;on the fly.&quot; 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:  Locate the following registry key:

Note This is the CLSID for the MSDAINIT object. 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.

Additional query words: MaxResLifeTime pooling

Keywords: kbinfo KB301384

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.