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

ID: Q244160

The information in this article applies to:

Microsoft Site Server version 3.0, Commerce Edition

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 this to be a problem in Site Server version 3.0, Commerce Edition.

Additional query words:

Keywords :
Version : winnt:3.0
Platform : winnt
Issue type : kbprb