December 12, 2020 at 8:20 am
Hi
I installed SSRS 2019 on a SQL SERVER 2019 enterprise edition and then installed the oracle client 19.
now strangely in SSRS data connection page I don’t see the option of Oracle but only available is OracleEssbase!
and this OracleEssbase my user cannot connect using this connection type.
any idea or suggestion how to get Oracle as a connection option for data source in SSRS ?
thanks
December 13, 2020 at 9:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 14, 2020 at 7:49 am
You need to use ODP.NET and I believe it has to be Oracle Client 18.0 for SSRS2019, don't quote me on that just from what I googled
December 14, 2020 at 3:07 pm
Thank you so much! I'll check it out
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply