New to Telerik Reporting? Download free 30-day trial

How to configure SQLite ADO.NET Provider for Stand-alone Report Designer


Product Version
Product Progress® Telerik® Reporting


Configuring the SQLite ADO.NET Provider for the Stand-alone Report Designer requires a few steps. If one is missed, the DataSource provider will not work in the Report Designer. Follow the below steps as to get this working.


Step 1 Download the SQLite installer per your desired version of the .NET Framework from the System.Data.Sqlite Downloads page.

Step 2 Copy the System.Data.Sqlite.dll file from the System.Data.Sqlite installation directory to the Report Designer installation directory.

  • SQLite Installation: C:\Program Files\System.Data.SQLite\2015\bin
  • Telerik Reporting Installation: C:\Program Files (x86)\Progress\Telerik Reporting R2 2019\Report Designer

The Telerik Reporting directory will look like the following:

sqlite install folder

Step 3 Add the DbProvider Factory declaration to the appropriate Stand-alone Report Designer configuration file. Telerik.ReportDesigner.exe.config is for 64-bit (x64) and Telerik.ReportDesigner.x86.exe.config is for 32-bit (x86).

When updating the configruation file, use the version that matches the installed SQLite ADO.NET Provider, i.e., 64-bit (x64) or 32-bit (x86).

                <remove invariant="System.Data.SQLite" />
                <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=, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

Step 4 Install the SQLite/SQLServer Compact Toolbox extension in visual studio. This will give you a similar experience to using Access.

See Also

In this article