sqlfriends - Tuesday, February 27, 2018 5:35 PM
The extension could be missing from the config file. In the ReportServer directory, there is a rsreportserver.config file that would have the extensions listed. Open that in a text editor and in the data section there should be all of the supported extensions listed. Oracles would be:
<Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
You pretty much want to always check the ReportServerService log file as it can provide additional information.
Sue