Post reply

Error when deploying report using Oracle data source

  • June 23, 2005 at 10:15 am

    #109916

    We use SQL Server Reporting Services, My SQL box is on Win2k3.  The developer is able to run the report on his Windows XP box but when he deploys the reports to the SQL Server where Reporting Services is running, he gets the following error: 

    "An error has occurred during report processing. (rsProcessingAborted) Get Online Help

    Cannot create a connection to data source 'WMS'. (rsErrorOpeningConnection) Get Online Help

    System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

    He develped this report on his XP box using Visual Studio .NET and is trying to deploy it to our SQL server production box where Reporting Services is installed.  I have installed Oracle 9.2 client on the SQL Server box and can make successful connections to our Oracle Database (where the report is pulling data from).  What else am I missing?

    Thanks!

    Bea Isabelle, Database Administrator

    Thanks!
    Bea Isabelle

  • June 27, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • April 5, 2006 at 8:49 pm

    #631136

    Hi,

    This problem "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" is related to permissions on the ORACLE_HOME (ora92) folder.

    The environment I experienced this under was Windows 2003 (Standard Edition), SQL Server 2005 Reporting Services (Developer Edition) - all standard install options on a standalone server with Oracle Client tools 9.2.1 against an Oracle 9.2 DB 

    Some other manifestations of the same problem depending on the ODBC or OLE/DB provider being used are:

    • "Specified driver could not be loaded due to system error 5 (Oracle in OraHome92)"
    • "The 'OraOLEDB.Oracle.1' provider is not registered on the local machine"

    The basic solution for this is to allow "Read and Execute" NTFS permissions for Authenticated Users" for the ORACLE_HOME (ora92) folder - see http://www.dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx or http://www.orafaq.com/forum/t/38330/0

    Note: You may also need to grant permissions to the ASP.NET, IWAM_ and IUSR_ accounts as described with checking that all subdirectories inherit the same permissions.

    However most importantly as I found after much frustration - it may be necessary to use the "Replace permissions entries on all child objects with entries shown here that apply to all child objects" option found under [ORACLE_HOME Folder] > properties > security > advanced.

    I also found some references about people having to reinstall Reporting Services however I believe this is unnecessary.

    Regards,

    Alex

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply