DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extracting data from Oracle DB using SQL Server Reporting Services

983176Jan 6 2013 — edited Jan 7 2013

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

George

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2013

Added on Jan 6 2013

#oracle-provider-for-ole-db, #windows-and-net

1 comment

5,471 views