Unable to connect to Oracle in Visual Studio 2022 Analysis service project

Mudassar A 491 Reputation points
2023-01-03T14:10:13.16+00:00

Unable to connect to Oracle in Visual Studio 2022 Analysis service project and getting the below error

Error
Details: "Failed to find or load the registered .Net Framework Data Provider.. This is a configuration issue with the file 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config'."

I followed instructions here - https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database#installing-the-oracle-client and installed oracle and can connect and work with Powerbi ( latest december release) but in Visual Studio2022 I m getting the error

Below are entries in the Machine config

   <DbProviderFactories>  
      <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />  
      <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.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />  
    </DbProviderFactories>  

</system.data>

Community Center | Not monitored
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.