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