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
- Download and install the FireBird ODBC driver from the provided link.
- Follow the installation instructions provided by the driver provider to complete the ODBC driver installation on your system.
Creating and Configuring the Connection
Click on the
Dataicon in the configuration panel of Bold Reports.
DATAconfiguration panel, click on the
In the connection type panel, select
ODBCin the DATA SOURCES pane, as shown in the image below.
Paste the ODBC Firebird connection string into the connection string textbox. The connection string should be in the following format.
Note: Replace the placeholders with your specific connection details, such as username, password, and database file location.
- Click on the
Savebutton to establish the connection between Bold Reports and your Firebird database.
- Click on
Connectto proceed with the query design pane. Enter the required query and execute it. The corresponding values will be displayed in a grid for preview.
- Preview the data in the query designer page to see the results of your Firebird query.