SSRS report with 32-bit Oracle Client Not working in 64-Bit Environment

Question

I have a SSRS report using 32Bit Oracle client build in BIDS 2008, Report is running fine in BIDS (VS 2008) but when deployed to Report Manager on Win2k3 64 Bit Server it is failing with the following error

"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."

I have gone through several articles which are suggesting to Enable IIS to 32Bit using csscript Enable32Biton64 'true' and aspnet_regiis-i, but problem with this is I have other application that needs 64-bit capabilities so cannot do it.

Please suggest me the way to do it .TIA.

Solution 1

Install the Oracle 64-bit client tools on the server, e.g.

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

Solution 2

This is the second time I configure a similar server, and the second time I spend hours figuring this one out. If for nobody else, I am writing this for the future me. This is for a Windows Server 2012 R2 64bit, 8GB RAM, 300+GB HDD, Intel Xeon CPU E5620 @ 2.40GHz, that is running Microsoft SQL Server Reporting Services 2012 64bit and IIS 7.0 with web applications that use the Oracle Client 32bit connection System.Data.OracleClient

1. Install the 64bit client
2. Change the name of the Oracle inventory directory @ "C:\Program Files\Oracle" to "C:\Program Files\Oracle64"
3. Restart computer and test for connection from SSRS to Oracle
4. Install the 32bit client and specify a different location for its home directory
5. Restart computer and test connection from SSRS to Oracle and from Web Applications to Oracle

I hope this helps my future self and others :)