4

In my project I am using oracle and entity framework together.Both of my machines my developer machine win7 and my server win2008r2 I installed oracle beta entity framework and .net 4.0 framework.

However my projects works on local machine and does not work on server giving the error : 

the specified store provider cannot be found in the configuration or is not valid 
SystemArgumentException unable to find the requested .net Framework data provider ...

Anyone can help me ?

Yaya
  • 600
  • 1
  • 11
  • 28
  • sounds similr to this question? :http://stackoverflow.com/questions/2433749/deploying-applications-that-use-linq-to-entities – Kevin Burton Sep 29 '11 at 12:10

6 Answers6

11

In the Application Pool and Advanced Settings...

Have a look at the "Enable 32-Bit Applications" and see if it is enabled. It wasn't set on my Windows 7 64bit and I had the same issues.

I am guessing it might also be fixed by installing the 64bit ODAC but haven't tried that yet.

Firedragon
  • 3,685
  • 3
  • 35
  • 75
  • This fixed it for me. In my case, I was using the ODAC 12.1 Managed Data Access driver which is 32-bit, but IIS on Windows 7 was not configured to run 32-bit by default. – Justin Skiles Sep 16 '13 at 16:39
  • This answer sort of led me in the right direction to get my problem fixed as well. Mine required modifying the Machine.Config file for the 64-bit 4.0 framework. I was trying to access an Oracle database through a .NET Console Application, but kept getting the same exception as the OP. After modifying the 64-bit Machine.Config to include the Oracle DB provider, it worked. I basically copied what was in the 32-bit Machine.Config for Oracle to the 64-bit Machine.Config. – Jagd Nov 26 '13 at 00:25
  • Last thing I considered being that I specifically installed the 64-bit version of the managed driver. I guess it's just a 64-bit installer. – Daniel Przybylski Nov 26 '14 at 18:36
3

I had this problem before. I followed these instructions then it solved: with windows 10 x64

1- Install Visual Studio 2015.

2- Install ODAC from http://www.oracle.com/partners/campaign/utilsoft-086879.html.

  1. install ODTforVS2015 from http://www.oracle.com/technetwork/topics/dotnet/downloads/odacmsidownload-2745497.html

  2. copy tnsnames file witch configured in step #2 and paste it to Network folder of destination installation of step #3.

  3. change C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\Machine.config <system.Data> tag like this:

    <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.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
<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.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>

  4. add this line in web.config for web app, or in App.config if it is console App. under <configurations> </configurations> tag (Under not inside).

    <system.data>
    <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.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
    </DbProviderFactories>
</system.data>
user3106510
  • 31
  • 1
  • Serious , you are genious ... Thanks a lot. I added above configuration in my app and it is working. :) – Bimal Das Jan 23 '18 at 11:17
2

in short: do not use ODAC .net drivers, instead use oracle client complete installation. modifying ODAC components may be a bit diffucilt. So install latest version of oracle client to all machines everything is well.

  • old answer - For both machines I installed first oracle data provider for .net and then oracle beta entity framework providers . So for both machines I have multiple oracle client instances.

In my development machine oracle beta entity framework is configured as default client. -I dont know when/how it changed/ who changed -

In server default provider is still old odp.net .

After changing the default provider at server to oracle beta entity framework provider it changed.

Thanks again.

Yaya
  • 600
  • 1
  • 11
  • 28
0

We were installing our application on a windows 2012 server and we were getting the same error, we tried to run the applications in the 32 bit mode , but results are same. we tried to get the list of DbProviderFactories installed in the machine by a console app and figured out that the ODP.net Managed Driver is missing. it finally worked when we ran the batch file we found

Kolathur
  • 41
  • 1
  • 2
0

If you are getting this error in 2018 and you are using IIS Express like I am, you may want to check your .csproj settings and ensure that it is running under x64 bitness. (Right click you web application's csproj, go to "Web" tab, under the "Servers" section, change the bitness to x64).

Pushkar Shembekar
  • 314
  • 2
  • 3
0

Installing ManagedDataAcces solved the problem for me.

Mr None
  • 33
  • 4