错误 找不到请求的 .Net 框架数据提供程序。它可能未安装。

Question

错误截图。

我在运行web应用程序时出现了上述错误。我最近安装了ODTforVS2019用于连接oracle数据库，因为收到了一个错误，说在安装了32位oracle客户端组件的64位模式下运行时会出现这个问题。但是现在在运行我的asp.net web应用程序项目时出现了这个错误。这将对解决这个错误有很大帮助。谢谢

***My web.config file***

enter code here<configuration>
<connectionStrings>
<add name="ConnectionString" connectionString="TNS_ADMIN=C:UsersmahatOraclenetworkadmin;USER ID=SAGAR;PASSWORD=dell;DATA SOURCE=localhost:1521/xe"
providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.7.2" />
<httpRuntime targetFramework="4.7.2" />
<pages>
<namespaces>
<add namespace="System.Web.Optimization" />
</namespaces>
<controls>
<add assembly="Microsoft.AspNet.Web.Optimization.WebForms" namespace="Microsoft.AspNet.Web.Optimization.WebForms" tagPrefix="webopt" />
</controls>
</pages>
</system.web>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Antlr3.Runtime" publicKeyToken="eb42632606e9261f" />
<bindingRedirect oldVersion="0.0.0.0-3.5.0.2" newVersion="3.5.0.2" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" />
<bindingRedirect oldVersion="0.0.0.0-12.0.0.0" newVersion="12.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-1.6.5135.21930" newVersion="1.6.5135.21930" />
</dependentAssembly>
</assemblyBinding>
</runtime>
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:1659;1699;1701" />
<compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:41008 /define:_MYTYPE=&quot;Web&quot; /optionInfer+" />
</compilers>
</system.codedom>
</configuration>

Answer 1

试图提供帮助，但您确定同时拥有Oracle Data Access Client和Oracle Data Provider吗？似乎两者都需要从.net建立对oracle数据库的访问。来源：https://www.oracle.com/pt/database/technologies/dotnet-utilsoft-downloads.html

这对于了解所需驱动程序/扩展程序之间的差异似乎非常有用http://www.dba-oracle.com/t_oracle_data_access_components_odac.htm