Use SQLite Data Source with C1FlexReportDesigner


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:

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:

                 <!--add tag here-->  

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=, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

Esha Dhir