Error Message: [Microsoft][ODBC SQL Server Driver][Named Pipes] Connection Broken (244160)


The information in this article 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.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb KB244160
©2004 Microsoft Corporation. All rights reserved.