Category / Section
Connecting Firebird Database with Bold BI using ODBC Driver
Published:
Firebird is an open-source SQL relational database management system that supports Linux, Microsoft Windows, macOS and other Unix platforms. To establish a connection with the Firebird in Bold BI make use of the ODBC Data Source. Please follow the outlined steps provided below.
- Please verify whether Firebird and Bold BI application is 64-bit or 32-bit, and create firebird connection in ODBC accordingly.
- Install the Firebird ODBC Driver
- Click Add in System DSN
- Select the driver and click finish.
- Enter the valid connection details.
Settings:
● Database:
○ For a local file database, select the database file (e.g. TrainingManager.tdb, VehicleData.vdb, or AssetManager.adb). In the file browser window, select “All Files” to remove the *.fdb filter from the file selection box.
○ For a remote database, enter the name of the server and the name of the database alias separated by a colon (no spaces).
● Client: [enter path to fbembed.dll or fbembed64.dll]. The fbembed.dll file is for 32 bit clients, and the fbembed64.dll file is for 64 bit clients. Note that the “client” in this case refers to the program that will connect. This will be the Windows ODBC Connection client when creating a connection and testing it, or the MS Access, Crystal Reports, etc. client when reporting or otherwise using another client to connect.
● Database Account: SYSDBA
● Password: masterkey
● Role: [leave blank]
● Extended Identifier properties: quoted identifiers
● Dialect: 3
6) Once the DSN is created, connect to this ODBC driver from Bold BI application.