An access violation may occur in the ASP.NET worker process if you try to view a report that is based on an Oracle database in Report Manager (840712)



The information in this article applies to:

  • Microsoft SQL Server 2000 Reporting Services

SYMPTOMS

When you create a report that is based on an Oracle database by using the OLE DB Data Extension and the Microsoft OLE DB Provider for Oracle, an access violation may occur in the Microsoft ASP.NET worker process if you try to view the report in Report Manager.

Also, Report Manager displays the following error message:

Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
You can preview the same report successfully in Report Designer.

Note On computers that are running Microsoft Windows 2000 or Microsoft Windows XP, the default ASP.NET worker process is Aspnet_wp.exe. On computers that are running Microsoft Windows Server 2003, the default ASP.NET worker process is W3wp.exe.

This problem occurs when either of the following conditions is true:
  • The computer that is running Microsoft SQL Server 2000 Reporting Services is not joined to a domain.
  • You install the Oracle Client 9.2.0.1, and you do not restart the computer after the installation.

WORKAROUND

To work around this problem, you can use the Oracle Data Extension and the managed Oracle provider.

Modification Type:MajorLast Reviewed:4/14/2005
Keywords:kbOracle kbASPNET kbOLEDB kbReport kbtshoot kbprb KB840712 kbAudDeveloper