Microsoft KB Archive/840712

= 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 =

Article ID: 840712

Article Last Modified on 4/14/2005

-

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 &quot;Refresh&quot; 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.

Keywords: kbtshoot kboracle kbreport kbprb kbaspnet kboledb KB840712

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.