Connection to SQLite DB from a report

2017-08-17

In this article I would like to see a connection to a SQLite database from a report. We will look at this in two examples. The first - with the help of plug-in for Report Designer, the second - with the help of ODBC SQLite driver.

  1. So, to use a plugin from FastReports, you must first make it. To do this, open solution FastReport.Net\Extras\Connections\FastReport.SQLite. The references need to fix two links - at the library FastReport.dll and System.Data.SQLite.dll. The last one will have to download from the Internet. Build the solution. We get FastReport.SQLite.dll library in the bin \ Debug folder.

Now open the report designer. On the File menu, select Options. Open the Plugins tab in the form that appears.

Use the Add button to add libraries created above. Restart the report designer.

On the toolbar, select the Report tab and add a new data source using the icon . In the appeared Data Wizard, click the button “New connection...”.

 

 Select the type of connection - SQLite connection. Below, we specify the path to the database. By default, the filter is set to extension "* .db3" in the window opening. My database has an extension of db, so that changes to ".".

 

As a result, to connect the database only need to select a database file. Click OK. In the Data Wizard click Next and proceed to the selection of tables:

 

That's all.

 

2. Now look at the second method - using SQLite ODBC Driver.

First you need to download and install this driver.

Open the report designer. Create a new data source, as above, by means of icon . Next, in the Data Wizard click the button “New connection ...”.

Select the ODBC connection. In the data source switch to the “Use connection string”. And sets the connection string using the icon .

In the window of selection data source, you need to create new data source. Select the SQLite3 ODBC Driver. Click Next.

 

 We set database connection.

 

Here we only need to select the database file using the Browse ... button. Click OK. Here is the configured connection:

 

Click OK and return to the Data Wizard. Click the Next button. And proceed to the choice of tables.

 

Thus, we have considered two ways to connect to the database SQLite. If you will often use this connection, I advise you to use the plug-FastReport.SQLite.dll - faster and more enjoyable to use. If you do not want to bother with the assembly  - use ODBC. But the second option will run a bit slower due to the extra layer.

September 19, 2024

How to troubleshoot the most common issues when installing FastReport VCL

We have compiled a list of the most popular problems when installing FastReport VCL and have prepared detailed instructions on how to fix the problems that have arisen.
August 12, 2024

How to build and install the Postgres plugin in FastReport .NET

This article describes how to connect to the database using the FastReport .NET plugin for the report designer from Visual Studio via the NuGet server.
August 08, 2024

How to install FastReport .NET and its components on Windows

Step-by-step instructions for online and manual installation via the FastReport registration code.NET and its components in Windows.
Fast Reports
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314

© 1998-2024 Fast Reports Inc.