User Rating!

Home > Search > Knowledge Base > SQL Server > Bugs and Fixes > Bugs and Fixes

PRB: SQL Application Role Errors with OLE DB Resource Pooling (Q229564)

Total Hits: 2130  |  Today: 0       Rating:

Read Reviews | Write Review |   Your Rating:  Select One 5 Stars - Best Rating 4 Stars 3 Stars 2 Stars 1 Star - Worst Rating

When you enable a SQL Server application role on a Microsoft ActiveX Data Objects (ADO) connection to SQL Server, you may receive the following error message when you connect to SQL Server 7.0: sp_setapprole was not invoked correctly. Refer to the documentation for more information.When you connect to SQL Server 2000, the error may appear as follows:[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation This error occurs when sp_setapprole is called on an ADO connection that has been allocated from the OLE DB resource pool. This error occurs with either the SQLOLEDB provider or the SQL Server ODBC driver.

DevASP.Net users Rating What is your opinion? 5 Stars4 Stars3 Stars2 Stars1 Star

Is this your listing?

If this is your listing and you like to add the rating box
displayed on the right side on your site you can use the following code.