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