SSRS with Oracle 11g

Question

we are trying to render report from SSRS using oracle 11g. when deploying we are getting an error saying looking for providers. p

Answer 1

Hi Prakashsat,

Have you installed and configured Oracle ODAC drivers in the machine?

Please refer to the following article about installing and configuring Oracle ODAC drivers which might help:

Oracle Connection Type

Configure Oracle data source for SQL Server Reporting Services

Best Regards,

Amelia

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

error saying looking for providers. p

You have to install ODAC (Oracle Data Access Component) on the machine where SSRS is running.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

To be able to use Oracle with SSRS 2016, you will only need to use Oracle ODAC drivers 12.2 or later!

Check the details at

• Oracle Connection Type ((Report Builder & Power BI Report Server) | Microsoft Docs)
• Oracle Providers
• How to install oracle Provider

---

[About Me] | [SPGeeks Blog] | [deBUG.to]

Answer 4

Hi Prakashsat,

Did the answers above help you?

Please feel free to let us know if you have any other question.

If you find any post in the thread is helpful, you could kindly mark it as answer. This would benefit the community, and encourage the community member to keep working on your issues.

Best Regards,

Amelia

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].