Skip to Main Content

ODP.NET

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!

Problems with Visual Studio 2019 and MS SQL Paginated RDL Reports and Connecting to Oracle

user585593Apr 6 2022 — edited Apr 7 2022

I am able to get visual studio 2019 working for c# and visual designers, but have not been able to get it to work with the Mircosoft Reports.

In the attached screenshot, you can see that the datasource to Oracle connects successfully on a test, but the designer states:
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.
Following the additional instructions from here:
Oracle Connection Type (SSRS & Power BI Report Server) - SQL Server Reporting Services (SSRS) (0 Bytes)
I then installed these 64 bit drivers
ODAC Runtime Downloads (0 Bytes)
And then ran the config file located in the installed drivers
../odp.net\managed\x64\configure.bat

and this did not help

Showing that data source connects to Oracle but report designer fails.png

Comments
Post Details
Added on Apr 6 2022
2 comments
414 views