Cannot load requested data provider: SqLiteProvider

 

1.  Make sure you have a reference to the driver for your database in your .NET project.

2.  Make sure that the reference has CopyLocal = true in the properties window

3.  Make sure that after you build the application, the driver actually exists in build directory (example bin\Debug or bin\Release)

4.  If the driver does not exist in the build directory it can be solved in one of two ways.

A.  Add a reference to the driver in the top most parent project instead of a sub project.

B.  Access any item in the driver assembly in the child assembly and then Visual Studio will then copy the driver to the build directory.

 

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

 

1.  Change your project build from Any CPU to either x86 if you have 32 bit Microsoft Access installed of x64 if you have 64 bit Microsoft Access Installed

 

Cannot load requested data provider: VistaDbProvider

1. The provider name VistaDbProvider is invalid.  You must use
   1. VistaDb4Provider if you are using Vista Db 4.x
   2. VistaDb5Net20Provider if you are using Vista DB 5.x with .NET 2.x through .NET 3.5
   3. VistaDb5Net40Provider if you are using Vista DB 5.x with .NET 4.x