BUG: Many WRITETEXT Calls Causes DB-Library Error 10005 (178642)


The information in this article applies to:

  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MinorLast Reviewed:3/14/2005
Keywords:kbBug KB178642
©2004 Microsoft Corporation. All rights reserved.