Clever Geek Handbook

Visual Studio. The specified storage provider could not be found in the configuration or is invalid

When trying to build / run a solution that the rest of my commands use without issue, I keep getting the following error messages.

  • At runtime, it throws an exception when the DbContext is instantiated: "The specified storage provider could not be found in the configuration, or is invalid."
  • With internal exception: "The requested .Net Framework Data Provider could not be found. It may not be installed."

With the same code / project / config, 3 other teammates have no problem with this.

We are using VS2013, EF 5.0, Oracle Client for .NET, Windows 7 x64 Connection string:

metadata=res://*/BpmModel.csdl|res://*/BpmModel.ssdl|res://*/BpmModel.msl;provider=Oracle.ManagedDataAccess.Client;provider connection string="DATA SOURCE=BpmOracle;PASSWORD=xxxxxxx;PERSIST SECURITY INFO=True;USER ID=xxxxxx;" providerName="System.Data.EntityClient"

So far we have tried:

  • Removing and reinstalling VS2013
  • Installing VS2014 Update 4
  • Created and updated the solution and workspace approximately 3-4 times
  • Entity Framework installed
  • TNSNames.ora is correct.

Any other things we could try to solve this puzzle?

+3


source to share


3 answers


Do you have the oracle provider registered in your app.config / web.config under the provider section? this and this for reference.



+1


source


I solved the problem. Switching to a 32 bit application in IIS did the trick.

More details:



  • Open IIS
  • Disable netlist (most likely computer name)
  • Click "Application Pools"
  • For each of the listed applications:
    • Right Click -> Advanced Settings
    • Set "Enable 30-bit Apps" to "True"
+1


source


My solution to this problem was to add the required configuration to the Web.config by installing the missing package via NuGet .

Right click your solution or project, click Manage NuGet Packages and set the missing Oracle link. This should change your Web.config with link.

+1


source






More articles:


All Articles