Microsoft KB Archive/289685

= PRB: Delay in OLE DB Session Pool When You Toggle Between No Connection and One Connection =

PSS ID Number: 289685

Article Last Modified on 12/1/2003

-

The information in this article applies to:


 * Microsoft Windows 2000 Server SP2
 * Microsoft Windows 2000 Advanced Server SP2
 * Microsoft Windows 2000 Professional SP2
 * Microsoft Windows 2000 Datacenter Server SP2

-



This article was previously published under Q289685



SYMPTOMS
When you use the OLE DB session pool, you must hold at least one connection while your application is running. If you close the last connection, and then start a new transaction moments later, you experience a 15-second delay before the new transaction is committed.



RESOLUTION
To work around this problem, do not toggle between no connection and one connection when you use the OLE DB session pool.

Alternative Resolution
Create an additional persisted connection from the client to initiate a session pool.



STATUS
This behavior is by design.

Additional query words: ADO SQL Server

Keywords: kbDatabase kbprb KB289685

Technology: kbwin2000AdvServ kbwin2000AdvServSearch kbWin2000AdvServSP2 kbwin2000DataServ kbwin2000DataServSearch kbWin2000DataServSP2 kbwin2000Pro kbwin2000ProSearch kbWin2000ProSP2 kbwin2000Search kbwin2000Serv kbwin2000ServSearch kbwin2000ServSP2 kbWinAdvServSearch kbWinDataServSearch

-

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

© 2004 Microsoft Corporation. All rights reserved.