Could not load Library: Failed to find or load the registered .Net Framework Data Provider

Support | Windows | User Guides and FAQ | Could not load Library: Failed to find or load the registered .Net Framework Data Provider

The Data Provider we use is our apps is SQLite.  This error indicates the .NET configuration for data providers on your system has been corrupted.  Normally because another application has installed itself into the global configuration and failed to clean up after itself when you have uninstalled it.  Here are 6 issues that may cause this error.

  1. There is no System.Data.SQLite.dll in the program folder. Please go to the folder in Program Files or Program Files (x86) on x64, JakstaTechnologies\<program name> to verify that the file is present. 
  2. The System.Data.SQLite.dll in the program folder is corrupt for some reason. Check the file's size & version, for series 6 Jaksta products it should be 992KB and v 1.0.92.0.
  3. System.Data.SQLite has been added to the machine.config file and it is pointing to something that no longer exists. Another app added it, and it has since been removed but not cleaned up the machine.config. Look in Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config. Apps should not put SQLite config in this file as it breaks any other app (like ours).
  4. Microsoft Visual C++ 2010 is not installed. Check your listing of installed software via the Control Panel.
  5. Another version of System.Data.SQLite has been registered globally and is overriding the local one.  Check the global assembly cache - Windows\assembly. Again apps should not add SQLite to the global assembly cache, but some do and break other apps (like ours)
  6. Another app has corrupted the machine.config file in some way.  It contains Data Provider entries that are corrupt or pointing to assemblies that are corrupt or no longer installed.

Example error message:

blob1477951743210.png