SSRS - The selected data extension ORACLE is not installed or cannot be loaded

Question

Hi,

I tried to migrate our SSRS to a new plateform.

All wis working exept test datasource in ReportBuilder.

I have this error message :

The selected data extension ORACLE is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports.

I tried to follow this KB : https://debug.to/2492/ssrs-the-selected-data-extension-oracle-is-not-installed-or-cannot-be-loaded

But it doesn't work for me.

• SSRS 2022
• ODAC 18.3 (i tested ODAC 19.3 too)
• Oracle Database 11G/19C

Can you help me please ?

Thanks for your help,

Matt

Answer 1

Hi,

I resolved my problem by install [Oracle Client for Microsoft Tools]

https://www.oracle.com/database/technologies/net-downloads.html

First, i uninstalled all Oracle components on SSRS Server.

After, i installed 64 bits version on SSRS Server side and 32 bits version on client side executed ReportBuilder.

Matt