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.

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

<http://www.oracle.com/technetwork/topics/winx64soft-089540.html>
Please isntall 64 bit oracle, copy tnsnames.ora and reboot the server, I had same issue and it worked fine after doing it.