Microsoft Fixes Invalid Cursor State

Microsoft has released a hotfix for an invalid cursor state that occurs after you apply hotfix build versions between 8.00.0859 and 8.00.0875 in SQL Server 2000 Service Pack 3 (SP3). Applications that execute a stored procedure that uses a SET NOCOUNT ON statement and that return one or more result sets following an informational message, a RAISERROR statement, or a PRINT statement, might have various failures in processing results. The error message differs depending on what client API you're using. Common error messages include "ADO: Operation is not allowed when the object is closed" and "ODBC: \[Microsoft\]\[ODBC SLQ Server Driver\]Invalid cursor state." This bug also affects the Design Table feature in Enterprise Manager. To learn more about the problem and the supported hotfix, read the Microsoft article "FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000" at

   http://support.microsoft.com/?kbid=831997

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish