Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

ssrs 2008r2 - Oracle 64bit access problem from Report builder 3.0

Avatar of Kpt12
Kpt12 asked on
DatabasesOracle Database
2 Comments1 Solution3455 ViewsLast Modified:
Hi,

I have provided environment details as below. I have created shared oracle datasource using TNS. and tested connection successfully using SQLPlus. But when I try to access oracle datasource to create new report from Report Builder 3.0 , once I select database and tested connection successfully , It is asking for password. and By entering password it shows error. (I checked user credentials different way its working when testing connection. I am getting different error from local machine and client machine as described below)

Is this an issue with reporting service configuration or its oracle side connectivity problem. How can I solve this problem? Is it required to install 'Client Tool Connectivity' shared feature for oracle database connection?
Error from local machine ssrs 2008r2 64bit installed with Oracle client 64bit (using oracle client, I am able to access oracle but when I try though Report Builder it gives error as follows )
Unable to connect to datasource 'ORACLE'
An attampt was made to load program with an incorrect format (Exception from HRESULT : 0x8007000B )
Attempt to load oracle client libraries threw BadImageFormatException. This problem will occur when running in 64bit mode with 32bit oracle client components installed.

Error from Client machine when accessing oracle datasource from Report builder (As Report builder access through report manager, oracle client did not installed in this machine )
Unable to connect to datasource 'ORACLE'
System.Data.OracleClient requires Oracle Client software verson 8.1.7 or greater

Steps taken to solve problem:
Provided full access permission to oracle home folder
checked oracle and oracle client version. Its 64bit.

Environment   (from ssrs installation log file)
OS version:                    Windows Server 2003
  OS service pack:               Service Pack 2
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No
Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         F:\MSSQLInstall\........
  Installation edition:          ENTERPRISE  
Feature:                       Reporting Services
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

(From Oracle client log)

OraClient11g_home2
      Oracle Client 11.2.0.1.0
HOME SELECTION
--------------------------------------------------------------------------------
Central Inventory Location: "C:\Program Files\Oracle\Inventory"
Oracle Home           Status
OraClient11g_home2    Selected
PATH = C:\oracle\product\11.2.0\client_1\bin;
C:\Program Files (x86)\Windows Resource Kits\Tools\;
C:\Perl64\site\bin;
C:\Perl64\bin;
C:\Program Files (x86)\Support Tools\;
..........
Oracle 64bit, oracle client 64bit installed on ssrs machine.

Thanks

ASKER CERTIFIED SOLUTION
Avatar of Kpt12
Kpt12

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answers