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.
HFK-IKTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
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.
0
HFK-IKTAuthor Commented:
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.
0
slightwv (䄆 Netminder) Commented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

HFK-IKTAuthor Commented:
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?
0
slightwv (䄆 Netminder) Commented:
I'm not a Report Services person so I cannot help specifically with that.  I'm only thinking it is a bit incompatibility based on what you posted in the original question.

All Oracle products can be downloaded from oracle.com.

If you were installing the 'full' client you can find the download here:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HFK-IKTAuthor Commented:
I reinstalled 64bit oracle client and the problem is solved. Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.