I am using SQL Server Reporting Services (SSRS), and I am using Report Builder to create a report from Oracle database. So I created a new report and I added a new data source with OLE DB as a Connection Type, and then I clicked on Build button to configure the connection properties with Oracle Provider for OLE DB.
I provided the server name and the UserName and Password correctly but when I clicked on Test Connection button, I got the below error:
Unable to connect to Data source
The OraOLEDB.Oracle provider is not registered on the local machine
Why I got this error and How I can configure Oracle Data Source in SSRS Report Builder?