I am getting this error when I am using ODP.net The error is appearing when I include a connection
<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="BannerCS" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="BannerCS (Web.config)" ParameterPrefix=":" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.BannerCS.ConnectionString" Provider="Oracle.ManagedDataAccess.Client" />
in the .XSD file in the website project I have the following connection in the web.config file
<add name="BannerCS" connectionString="DATA SOURCE=******;PASSWORD=**********;PERSIST SECURITY INFO=True;USER ID=*********"
providerName="Oracle.ManagedDataAccess.Client" />
I am able to see the data by running the SQL query in the data table in the Data set. The website project that is based on .net 3.5 also does not give any error in compile time . But when I run the application it gives this error.
Also when I add reference to the
Oracle.ManagedDataAccess.dll
by adding this in the web.config
<add assembly="Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
it give this error
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
This error comes at .net version 3.5 The solution is to upgrade the .net version to .net 4.0 or above