View Single Post
 
Old 08-10-2015, 07:23 PM
gpraceman's Avatar
gpraceman gpraceman is offline
Contributor

* Expert *
 
Join Date: Sep 2002
Location: Highlands Ranch, CO
Posts: 560
Default Problem filling DataTable from SQLite database

I have a desktop app using WinForms and am adding support for SQLite data files to it. I can connect to the data file and pull up data in the forms no problem, but I run into a "The 'System.Data.SQLite' provider is not registered on the local machine." error when trying to pull up a report with ReportViewer 2010.

I've done a bit of searching around and have added the following entry to my app.config file, but still get the error.

Code:
    <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, Version=1.0.97.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
      </DbProviderFactories>
    </system.data>
The System.Data.SQLite.dll file is copied to the local app folder.
__________________
Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.

Last edited by gpraceman; 08-11-2015 at 01:22 PM. Reason: Clarifying the thread title
Reply With Quote