Can't find what you're looking for?

Contact us or post in our forums and we'll help you find an answer.

Use SQLite Data Source with C1FlexReportDesigner

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>  
                   
        </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" ></add>
Get the Latest Version of WinForms Edition
Download the Free Trial Now