DbProviderFactory problem

I recently saw a new problem that showed up as the message below:

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

After a long search, i found that the machine.config file (at Windows\Microsoft.Net\Framework\v2.0.50727\config) wasn’t correctly configured with my actual provider (in my case Oracle.DataAccess.Client) thus i had to add the following to my web.config:

	<system.data>
		<DbProviderFactories>
      <remove invariant="Oracle.DataAccess.Client" />
      <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.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
		</DbProviderFactories>
	</system.data>

Alternatively, you can add that to your machine.config file if you want it for all of your applications and not just for one specifically.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s