Unable to find the requested .Net Framework Data Provider. It may not be installed.

Question

User-1840844002 posted

I have Oracle 10g installed on my machine.

Error :

Unable to find the requested .Net Framework Data Provider. It may not be installed.

Line of code :

DbProviderFactory objFactory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");

(Working fine if i am using other options rather than DbProviderFactory)

Assembly :

Oracle.DataAccess (In GAC, i have version 10.1.0.200 only).

Please help me sort this error. Thanks

Answer 1

User269602965 posted

What operating system?

32-bit or 64-bit operating system?

Answer 2

User-1840844002 posted

32 bit OS

Answer 3

User269602965 posted

I would download the latest version of ORacle ODP.NET for 11gR2,

during installation, use the CLIENT INSTALL prompt,

install into a NEW Oracle Home directory.

This will put many versions of ODAC in the GAC.

This 11g client will then communicate with your 10g Oracle Database via TNSNAMES.ORA

Also, there are two versions of ODAC dll, one supporting ASP.NET 2.0/3.5 and one supporting ASP.NET 4.0.

so you have to be careful which one you are pointing too.

Optionally, I will get the version of ODAC from the database HOME / ODP.NET / BIN folder and place the ODAC DLL

in my application BIN folder and make a local reference to it, bypassing need for GAC.