Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Reporting Services on 64bit

Posted on 2011-10-05
6
Medium Priority
?
862 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:HFK-IKT
  • 3
  • 3
6 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36916539
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
 

Author Comment

by:HFK-IKT
ID: 36916750
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
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36917178
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:HFK-IKT
ID: 36917486
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
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 36918022
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
 

Author Comment

by:HFK-IKT
ID: 36941636
I reinstalled 64bit oracle client and the problem is solved. Thanks.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses
Course of the Month12 days, 2 hours left to enroll

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question