1 Reply Latest reply on Jan 7, 2013 12:24 PM by Tridus

    Extracting data from Oracle DB using SQL Server Reporting Services

      Hi All

      Running Oracle 11G on AIX, and SSRS in Win2008 Server x64. Have installed the Oracle Client DACs. I am able to use OLEDB within Visual Studio to define the datasource and dataset and show the report by previewing it in SSRS. However when I define the same data source on the webserver itself, and test it, I get The "'MSDAORA.1' provider is not registered on the local machine." NO doubt I would assume this has something to do with SSRS running in x64, and Visual Studio in x32 bit mode.

      Can someone please direct me of the following:

      1. The steps involved to install both the 32 and 64 bit data access components for Oracle on a Win 2008 Server x64bit box
      2. How to setup an Oracle OLEDB or ODBC datasource on the SSRS webserver.

      Thanks in advance