Issue with connecting SSRS 2008R2 with Oracle 10g/11g

• aravind-305595

  Ten Centuries

  Points: 1389

  More actions

  April 18, 2012 at 1:22 am

  #254327

  Hi,

  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.

  I also installed ODAC as mentioned in another thread

  https://forums.oracle.com/forums/thread.jspa?threadID=555992

  Please let me know if there is some compatibility issue with any of the versions between SSRS and ORACLE or I need to install any other stuff to proceed.

  appreciate your response,

  thanks,

  Aravind.