ODP.NET not found

Hi,
I installed ODP.NET and everything seems correct (I could add the reference to the project). However, if I use the wizard to create a new connection, I get the error: "unable to find requested .net framework data provider. it may not be installed".

I also checked in the machine.config file, and the reference seems fine:
<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />

Why then do I get that error?
Any help is appreciated,
thank you

Re: ODP.NET not found

It may be cause of version problem. You have installed version 4.1 of Oracle. Check the documentation of oracle for appropriate version of .net frame work.

Re: ODP.NET not found

Hi,
the version 4.1 refers to the Oracle Data Provider dll, which is perfectly compliant with Oracle 11 (which I use). So, it's definitely not a version problem.

Thank you

Re: ODP.NET not found

Hello aletheia2

Considering that this is a 3-rd party controlMicrosoft cannot do much comments to thatas far as I seeyou can try to do configurations hereMake sure that all of your configuration values are right

<DbProviderFactories>
<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>

Re: ODP.NET not found

Hi,
for some reason, the problem was in the machine.config file.

In the <system data> section you have to make sure that there are only the opening and closing tags <DbProviderFactories> </DbProviderFactories>. All addictional tags must be removed.
After this change, the error hasn't shown up anymore.

I just wonder why there is no official documentation about such basic troubleshootings...

Thank you