Microsoft KB Archive/244160

= Error Message: [Microsoft][ODBC SQL Server Driver][Named Pipes] Connection Broken =

Article ID: 244160

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Site Server 3.0 Commerce Edition

-



This article was previously published under Q244160



SYMPTOMS
A large number of Ad items can cause Performance pages in Ad Manager to break with the following error message:

[Microsoft][ODBC SQL Server Driver][Named Pipes] Connection Broken



CAUSE
This error occurs because the record sets used in the Performance pages are not explicitly closed (using the .Close method of the record set), nor are they set to Nothing. ASP garbage collection is not fast enough to clean up after this code when it's called rapidly many times.



RESOLUTION
To resolve this issue, edit the Wwwroot/Admanager/Include/Performance_funcs.asp file. Add the following lines at the end of the procedure WritePerfPage:

rsPerf.Close

set rsPerf = Nothing

rsEvent.Close

set rsEvent = Nothing



STATUS
Microsoft has confirmed that this is a problem in Site Server version 3.0, Commerce Edition.

Keywords: kbprb KB244160

-

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

© Microsoft Corporation. All rights reserved.