forum

home / developersection / forums / unable to find the requested .net framework data provider. it may not be installed

Ask Question

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

Sachin Singh 3759 16-Mar-2016
Hi Everyone,
I want to add Sql server 2012 in my application and when i want to run my application it will give a following error:
Unable to find the requested .Net Framework Data Provider. It may not be installed

Please anyone give me any solution.
Thank you.
asp.net c#  asp.net  asp.net mvc  database connection  routing 
Updated on 17-Mar-2016
Sachin Singh

Other

Follow
Can you answer this question?
Answer

1 Answers

Anupam Mishra

Anupam Mishra

17-Mar-2016
Hi Sachin,

For solving above problem you should go the below link in your local computer


\Windows\Microsoft.net\Framework\v****\machine.config


And add  in the section of <system.data>.


<system.data>
    <DbProviderFactories> <add name="Odbc Data Provider" invariant="System.Data.Odbc"/>
     <add name="OleDb Data Provider" invariant="System.Data.OleDb"/>
     <add name="OracleClient Data Provider" invariant="System.Data” />
     <add name="SqlClient Data Provider" invariant="System.Data” />
     <add name="IBM DB2 for i .NET Provider" invariant="IBM.Data/”>
     <add name="Microsoft SQL Server Compact Data Provider"/>     
    </DbProviderFactories>
</system.data>

 

After that remove <DbProviderFactories/> empty tag.


Or , you can also solve the issue by nuGet

 

Go to Tools > Library Package Manager > Manage NuGet Packages For Solution

In the dialog, search for "EntityFramework.SqlServerCompact". You'll find a package

with the description "Allows SQL Server Compact 4.0 to be used with Entity

Framework." Install this package.

advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy