How to Connect to a FireBird Data Source in Bold Reports

A Firebird Data Source is a connection point for accessing and manipulating data using the Firebird RDBMS. Firebird is an open-source database with high performance and reliability. A Data Source includes details such as the server address, port number, authentication credentials, and specific database. Data Sources enable applications to interact with Firebird databases for tasks like querying and managing data.

Currently, FireBird is not directly supported in Bold Reports. However, you can connect to it using ODBC data connectors. To connect to FireBird using Bold Reports and ODBC, follow these steps.

Install Firebird ODBC Driver

1. Download and install the FireBird ODBC driver from the provided link.
2. Follow the installation instructions provided by the driver provider to complete the ODBC driver installation on your system.

Creating and Configuring the Connection

1. Click on the Data icon in the configuration panel of Bold Reports.

2. In the DATA configuration panel, click on the NEW DATA button.

3. In the connection type panel, selectODBC in the DATA SOURCES pane, as shown in the image below.
   

4. Paste the ODBC Firebird connection string into the connection string textbox. The connection string should be in the following format.

   DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=sa@1234;DBNAME=localhost:D:\DEMO.FDB;
   

   

5. Click on the Save button to establish the connection between Bold Reports and your Firebird database.
6. Click on Connect to proceed with the query design pane. Enter the required query and execute it. The corresponding values will be displayed in a grid for preview.
7. Preview the data in the query designer page to see the results of your Firebird query.