Geek Answers Handbook

C # Failed to find or load a registered .Net data provider error

I use SQLite and the shell from http://sqlite.phxsoftware.com/ , and when I add the data source to my project, I get the error:

"Some update commands cannot be generated automatically, the database returned the following error: Could not find or load the registered .Net Framework data provider"

I have the latest .Net service pack and I uninstalled and reinstalled SQLite software. I also looked at other places that suggest that this entry is not in the machine.config file:

<add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.27.1, Culture=neutral, PublicKeyToken=db937bc2d44ff139"/>

When I looked, I did not even find the machine.config file in the C: \ WINDOWS \ Microsoft.NET \ Framework \ v3.5 folder, but I found it in C: \ WINDOWS \ Microsoft.NET \ Framework \ v2.0.50727

Does anyone know what is going on? Do I need to uninstall the entire .Net Framework and then just install version 3.5 to fix this error?

Any help would be appreciated.

Thanks.

+2
c # system.data.sqlite
source share
4 answers

Can you add a direct link to System.Data.SQLite in your application and create an instance of SQLiteFactory?

We use SQLite with dll directly in our application bin manager (not GAC) and we have this line in our Web / App.config, therefore we do not rely on Machine.config (simplifies deployment).

 <system.data> <DbProviderFactories> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite"/> </DbProviderFactories> </system.data>
+6
source share

This can also happen if Microsoft Visual C ++ 2010 is not installed on the computer.

+1
source share

You do not need visual C ++ 2010 ... !!! Just copy "msvcr100.dll" to the release folder ...

For "System.Data.SQLite.dll" requires "msvcr100.dll"

+1
source share

I assume that you are using VS 2008. Check out the version of Framework that you are building to.

0
source share

More articles:


All Articles