Microsoft KB Archive/178642

= BUG: Many WRITETEXT Calls Causes DB-Library Error 10005 =

Article ID: 178642

Article Last Modified on 3/14/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q178642



BUG #: Windows NT: 17696 (6.5)



SYMPTOMS
After performing approximately 32,000 WRITETEXT or UPDATETEXT operations in a stored procedure, a DB-Library application will get DB-Library error 10005: "DBPROCESS is dead or not enabled." This problem does not occur with ODBC-based clients.



WORKAROUND
To work around this problem, do any one of the following;


 * Avoid using large numbers of WRITETEXT statements in stored procedures.
 * Run the WRITETEXT statements outside of the stored procedure in a batch.
 * Add SELECT statements to return data from the stored procedure between large numbers of WRITETEXT statements.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: Process command commands st proc stproc db lib dblib

Keywords: kbbug KB178642

-

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

© Microsoft Corporation. All rights reserved.