This discussion is archived
1 Reply Latest reply: Jul 22, 2013 5:47 AM by Srini Chavali-Oracle RSS

Failed to find or load the registered .Net Framework Data Provider in Oracle for asp.net application

RanjithKumarGnanaSekar Newbie
Currently Being Moderated

Hi,

string constr = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=spp01)(PORT=1521))(CONNECT_DATA=(SID=Global)));User Id=SYSMAN;Password=testman3";

            string ProviderName = "Oracle.DataAccess.Client";

 

 

            DbProviderFactory factory = DbProviderFactories.GetFactory(ProviderName);

 

 

I have asp.net application to show gridview.For a gridview datasource, I am using data from oracle database,but I could not connect with oracle database. I am able to connect to oracle in console and winforms application,but not in asp.net. I have installed 64bit ODAC. The ORACLE.DATAACCESS version is 2.112.3.0. I have checked machine.config entries in Framework64 v2.0.50727 and v4.0.30319

 

 

 

 

<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=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />

 

 

CPU = x64 Framework=3.5

 

 

When I run ASP.net application, I get the following error

 

 

System.ArgumentException was unhandled by user code

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

  Source=System.Data

  StackTrace:

       at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)

 

 

I have even set the apppool to allow 32-bit applications.

 

 

How do I resolve this error?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points