Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: RAISERROR Does Not Work with SQLOLEDB Provider
Article ID: 217019 - View products that this article applies to.
This article was previously published under Q217019
BUG #: 55618 (SQLBUG70)
When using the SQLOLEDB provider with server side cursors, the error description is not returned from a RAISERROR call inside a SQL Server procedure. An error is raised to the client, however, the description is not returned to the client. Instead the client only receives the following error message:
Run-time error '-2147217887 (80040e21)':
To work around this problem, try either of the following:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561For more information, contact your primary support provider.
(http://support.microsoft.com/kb/254561/ )INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
Steps to Reproduce Behavior
Article ID: 217019 - Last Review: March 14, 2006 - Revision: 6.1