INFO: OLEDB session pooling supports limit on connection lifetime

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.

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.