1 Reply Latest reply: Jan 7, 2013 6:24 AM by Tridus RSS

    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