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

  • 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

    Saturday, October 29, 2011 2:53 AM

Answers

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, October 30, 2011 4:22 PM

All replies

  • User269602965 posted

    What operating system?

    32-bit or 64-bit operating system?

    Saturday, October 29, 2011 5:34 PM
  • User-1840844002 posted

    32 bit OS

    Sunday, October 30, 2011 12:41 PM
  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, October 30, 2011 4:22 PM