Oracle not listed as connection type
Hello, when creating a new data source the Oracle connection type is not listed. The ODAC (x64 version) is installed. The oracle.dataaccess.dll is in the GAC (C:\Windows\Microsoft.NET\assembly\GAC_64\Oracle.DataAccess\v4.0_4.122.1.0__89b483f429c47342). in C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config there is an entry ---snip--- <configuration> <configSections> <section name="oracle.unmanageddataaccess.client" type="OracleInternal.Common.CustomSectionHandler, Oracle.DataAccess, Version=4.122.0.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> ... <system.data> <DbProviderFactories> <add name="ODP.NET, Unmanaged Driver" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET, Unmanaged Driver" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.122.0.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> </DbProviderFactories> </system.data> ... ---snip--- and similar in C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG. Anyway I cannot see the oracle connection type listed. In the Reporting Server log trace I can find: ---snip--- library!ReportServer_0-1!1694!08/14/2019-19:49:50:: i INFO: Call to GetSystemPropertiesAction(). User: ENZO-V1\Administrator. extensionfactory!ReportServer_0-1!1b54!08/14/2019-19:49:50:: e ERROR: Exception caught instantiating ORACLE report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed. at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper.CreateOracleConnection() ---snip--- Somehow I have the feeling it is because of the providerInvariantName. If I execute the following code snippet on the report server: var mcs = DbProviderFactories.GetFactoryClasses(); foreach(DataRow mc in mcs.Rows) { Console.WriteLine(mc[0]); } I get this output: Odbc Data Provider OleDb Data Provider OracleClient Data Provider SqlClient Data Provider So, the oracle data provider is not listed. I added the entries from machine.config (see above) to C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config and C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config (before it was in Framework64). Then the output was Odbc Data Provider OleDb Data Provider OracleClient Data Provider SqlClient Data Provider ODP.NET, Unmanaged Driver However, after restarting the service the Oracle connection type is still not listed and I get the same error in the log (Unable to find the requested .Net Framework Data Provider). Thank you for help. Hagen
