I tried to look at the data connection between my visual studio and SQL server, however it keeps on saying "Unable to find the requested .Net Framework Data Provider. It may not be installed." How can I get this fixed please? It was working before, suddenly it stopped working. I checked in the C:/windows/assembly System.Data.SQLClient is not there.
2 Answers 2
Ensure that the provider factory is registered with an appropriate entry in the machine.config.
-
Is there a way I can reset my machine configSeesharp– Seesharp03/06/2012 20:21:11Commented Mar 6, 2012 at 20:21
-
you do not need to reset the machine.config. Just locate the 'DbProviderFactories' node (add it if it is missing) and add the node for the System.Data.SqlClientalwayslearning– alwayslearning03/06/2012 20:39:02Commented Mar 6, 2012 at 20:39
In my case I was selecting the worng reference. For some reason x86 works, while x64 does not (in my case). Simply don't forget to reference System.Data.SQLite.dll
and/or System.Data.SQLite.Linq.dll
.
Explore related questions
See similar questions with these tags.