I am trying to connect the Oracle data source for the SSRS reports, The SSRS version is 2008 R2 (64 bit) and I have two Oracle servers (one is 10g and other is 11g, both are 64 bits). I have Oracle client 32 as well as 64 bit installed in the SSRS server.
I get different error for each data source I try,
1. Data Source : Oracle (OracleClient)
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
2. Data Source : Oracle provider for OLE DB
The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.
3. Data Source : Microsoft OLE DB provider for Oracle
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.