Last post Oct 30, 2011 04:22 PM by Lannie
Oct 29, 2011 02:53 AM|suparn1904|LINK
I have Oracle 10g installed on my machine.
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)
Oracle.DataAccess (In GAC, i have version 10.1.0.200 only).
Please help me sort this error. Thanks
Oct 29, 2011 05:34 PM|Lannie|LINK
What operating system?
32-bit or 64-bit operating system?
Oct 30, 2011 12:41 PM|suparn1904|LINK
32 bit OS
Oct 30, 2011 04:22 PM|Lannie|LINK
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.