Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

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 3903 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.netasp.net mvcdatabase connectionrouting
Updated 17 Mar 2016
Sachin Singh
Sachin Singh

Other

Message

1 Answers

Anupam Mishra
Anupam Mishra 17 Mar 2016
Report Abuse
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.

MindStick Training