Import History Delete Fails with Error 40002 [S1000] (193307)


The information in this article applies to:

  • Microsoft Site Server 3.0
This article was previously published under Q193307

SYMPTOMS

If you delete an imported log from the Import History, you may receive the following error message:
40002 [S1000] [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

CAUSE

Certain ODBC driver versions are confused by the operations performed on a single database handle during the request deletion process.

RESOLUTION

To resolve this problem, apply the latest Site Server 3.0 service pack.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Site Server version 3.0. This problem has been corrected in the latest U.S. service pack for Microsoft Site Server version 3.0. For information on obtaining the service pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

S E R V P A C K

MORE INFORMATION

Usage Import has been modified to divide the operations among two database handles to avoid this problem.
Modification Type:MinorLast Reviewed:9/22/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix kbQFE kbSiteServer300sp2fix KB193307 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.