created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)
any thoughts or direction greatly appreciated
Most likely the RS web service and the RS windows service cannot access the Oracle client installation due to missing file system permissions. Please read the following KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
-- Robert
|||Robert,
Thanks for the help, this did in fact solve the issue (once the permissions were granted for the entire Oracle directory). Why would such a helpful article not show up in my searches through the help maze? Is there another entry point to search for these articles other than the help search engine?
thanks again,
Richard
|||Wow this really helped me out also, had the exact same problem. Thanks. I too had to set the permissions for the entire Oracle directory for this to work. Also take note of which account your installation is using, mine wasn't using the Network Service account but instead a special service account created by the system admins, I had to set the permissions for that account on the folders.
Dave
No comments:
Post a Comment