Avatar of HFK-IKT
HFK-IKT
Flag for Norway 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.
DB Reporting ToolsWeb ServersOracle Database

Avatar of undefined
Last Comment
HFK-IKT

8/22/2022 - Mon
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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
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)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
HFK-IKT

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