I have a SQL Server Reporting Server R2 installed on a Windows 2008 R2 machine. I want to store and run a report that selects its data from an Oracle 11g server. I have installed ODTwithODAC112012 on the windows machine where the report server is installed.
Using report Builder 3.0, on the report server itself, I can select the oracle datasource and view the report data.
When I upload the report to the report server, it than fails to connect to the oracle datasource saying:
An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'XXXX'. (rsErrorOpeningConnection) System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
I figured maybe to give special permissions to the NETWORK SERVICE user that runs the report server, for the folder the oracle client is installed on the machine?
After I gave the service the permissions I got another error actually claiming that my client is Oracle is 32bit, not running as 64bit:
An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'XXXX'. (rsErrorOpeningConnection) Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
Will report server support oracle client 64bit ? this page is not that clear. link text
Please help... Amit