Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle.DataAccess.Client error on edmx file

user8879148Feb 23 2016 — edited Feb 29 2016

Hi everyone,

I got a project of a C# console application (x64) in .NET 4.0 that uses Entity Framework 5.0 with a connection to Oracle Database 11GR2 (version 11.2.0.4).

I installed on my PC

1) Oracle client version 11.2.0.4

2) ODAC x64 of the same version (xcopy)

3) ODT for VS 2013

But I can't generate binaries with Visual Studio 2013 from sources I received.

The only error I have is from an edmx file (the only one in this project) with the following message :

"The ADO.NET provider with invariant name 'Oracle.DataAccess.Client' is either not registered in the machine or application, config file, or could not be loaded"

But I noticed in the machine.config file in C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config that there are many lines indicating 'Oracle.DataAccess.Client', but it is not the case for the machine.config file in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config

So I tried to add these new lines in the latter machine.config, then the error message changed to :

"Failed to find or load the registered .Net Framework Data Provider."

What may seem logical to me since I've done an installation of ODAC in x64 version and not x86.

This leads me to think that in my VS, despite the fact that my project is configured for x64 platform, it doesn't use the right machine.config. Is it possible ?

Is there something missing on my machine ? What changes should I bring ?

Note : my machine runs with Windows 7 Pro x64.

Thanks in advance.

This post has been answered by Alex Keh-Oracle on Feb 26 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2016
Added on Feb 23 2016
5 comments
8,746 views