Microsoft KB Archive/193307

= Import History Delete Fails with Error 40002 [S1000] =

Article ID: 193307

Article Last Modified on 9/22/2005

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



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.

Keywords: kbbug kbfix kbqfe kbsiteserver300sp2fix kbhotfixserver KB193307

-

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

© Microsoft Corporation. All rights reserved.