Background:
How to use SQLite Data Source with C1FlexReportDesigner
Steps to Complete:
1. Uninstall current version of System.Data.SQLite on the machine.
2. Reboot the system.
3. Download sqlite from: https://system.data.sqlite.org/downloads/1.0.103.0/sqlite-netFx40-setup-bundle-x64-2010-1.0.103.0.exe
4. Install it. During the installation, ensure that "install assemblies into gac" option is checked.
5. On a 64-bit machine, two machine config files exist:
a. C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
b. C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config
6. Find the below tag in both the files:
<system.data>
<DbProviderFactories>
<!--add tag here-->
</DbProviderFactories>
</system.data> 7. And add this option:
<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.103.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
Esha Dhir