Oracle data source error Report Server 2019 (works in report builder)

Question

I have SQL Server Reporting Services (Version 15.0.7842.32355)

I am getting the following error for my connection to oracle
Couldn't connect
The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.
Hide error details
An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services.

I know the connection works as it is successful in report builder and VS2019 on the same machine running the report server.

I have 2 oracle clients installed

• ODTwithODAC122011
• ODAC122011_x64

Everything seems to be working other than reports trying to connect to oracle from the Reporting Services UI

Any ideas?

Answer 1

Hi @Asher Brooks
According to my research, the client will use 32bit, and Server use 64bit, so you need to install two version to test and you can refer to this link: https://stackoverflow.com/questions/39776069/ssdt-in-visual-studio-2015-oracle-connection-issue.
For more details, you could refer to https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-2017 and https://learn.microsoft.com/en-gb/archive/blogs/dataaccesstechnologies/configure-oracle-data-source-for-sql-server-reporting-services-ssdt-and-report-server
Best regards,
Aniya

Answer 2

Hi @Asher Brooks ,

Which Edition of the SSRS are you using? You may check in Report Server Configure Manager.

If you are using Express Edition of SSRS, here is a limit to connect to reemote and non-SQL data source support.

Please have a double check.

reporting-services-features-supported-by-the-editions-of-sql-server-2016

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

I have finally resolved the issue.

I uninstalled all existing oracle drivers and re-installed them.

The difference this time is that I installed the drivers on the same drive as my SQL server install (E:) so that the driver folders and paths matched the documentation provided by @AniyaTang-MSFT
https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-2017

I have both drivers installed and working in Report server UI.