asked on

Reporting Services on 64bit

I'm struggeling to view deployed reports. The reports are connected to an oracle 10g server. The error i get is:
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.

This is the setup:

The server with the IIS and Reporting Services is a Windows 2003 64bit server with oracle11gr2 client installed.

The reports are deployed through Visual Studio from a client computer with Windows 7 32bit. And the reports works fine from Preview within Visual Studio.

slightwv (䄆 Netminder)

You cannot mix and match 64Bit apps with 32bit libraries. At least I've not seen it.

If the app is 64Bit you will likely need a 64Bit Oracle Client.

HFK-IKT

ASKER

How do i select if the app is 32 or 64bit? The Oracle client should be 64bit. At least all the references is in Wow6432Node/Oracle in the registry.

slightwv (䄆 Netminder)

The quickest way is if part of the app is running, find it in task manager. There will be a *32 beside the process name for 32bit apps.

I'm not a Windows Admin. There might be other ways but I don't know them.

>>with the 32 bit Oracle client components installed.
>>The Oracle client should be 64bit

These two comments are confusing. Please clarify.

HFK-IKT

ASKER

The app is just a report that im trying to view through reporting services in IIS. So it does not run as a process. The Oracle client I downloaded for 64bit from oracle.com. Can you link me to an 11g client for 64 bit?

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

HFK-IKT

ASKER

I reinstalled 64bit oracle client and the problem is solved. Thanks.