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

reporting-services bids oracleclient badimageformatexception
BIMINDS picture BIMINDS · Dec 13, 2012 · Viewed 11.5k times · Source

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

Mike Honey picture Mike Honey · Dec 14, 2012

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

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

Related questions

SSRS - Expression using different dataset fields

I have a report with multiple data-sets. Different fields from different data-sets are used in different locations of the report. In one part of the report, I need to do a calculation using fields from two different data-sets. Is this …

Read More
Default Values for Parameter not Working in SSRS 2008 R2

I have a report (BIDS SSRS 2008 R2) that has a parameter that allows the user to select multiple values from a list (Sales Regions, lets say). I want, though, since the list is long (15 or so possible values) have selected …

Read More
How do I display 'No data available.' when there are no rows to show on the report?

I am building an SSRS 2005 report using BIDS. My report filters on date. When the selected date returns no data rows the report is blank, just the title is displayed, no table or column heading. How can I change this …

Read More