# Firebird Database Connection **URL:** \ **Category:** Ignition\ **Created:** [May 5, 2022, 9:32am UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241 "2022-05-05T09:32:08Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Jayden](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jayden](https://forum.inductiveautomation.com/u/Jayden)\ **Post date:** [May 5, 2022, 9:32am UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/1 "2022-05-05T09:32:08Z")
Hi All, I have a need to connect to a Firebird database. I’m wondering if anyone out there would be able to assist with some guidance on how to get this connection working. TIA ---
**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\ **Post date:** [May 5, 2022, 9:39am UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/2 "2022-05-05T09:39:45Z")
We have done this. Have you got the Firebird JDBC Driver installed? ---
**Author:** ![Jayden](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jayden](https://forum.inductiveautomation.com/u/Jayden)\ **Post date:** [May 5, 2022, 9:17pm UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/3 "2022-05-05T21:17:19Z")
Hi Jonathan, Yes I have downloaded jaybird 4.0.6 JDBC driver and have created a new JDBC driver on the in Ignition with the following data. I uploaded the following JIC files from the downloaded driver ZIP to the newly created Ignition driver: jaybird-4.0.6.java11 jaybird-4.0.6.java11-javadoc jaybird-4.0.6.java11-sources jaybird-full-4.0.6.java11 I have entered the following for the driver fields: Name: Jaybird 4.0.6 Desc: Driver for Firebird Database Class Name: org.firebirdsql.jdbc.FBDriver (Not sure if this is correct) Driver Type: FIREBIRD URL Format: jdbc:firebirdsql://host[:port]/ URL Instructions - Blank Default Connection Properties: Blank Connection Property Instructions : Blank Default Validation Query: SELECT 1 Default Translator: MSSQL I’m not sure if I’m on the right path with what I’ve done so far. Jayden ---
**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\ **Post date:** [May 6, 2022, 8:47am UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/4 "2022-05-06T08:47:12Z")
Couple things to change. URL Format: jdbc:firebirdsql:host[/port]:/path/to/db.fdb > Example: jdbc:firebirdsql:10.1.1.1/3050:C:\dbLocation\dbFile.fdb Default Translator should be Firebird also ---
**Author:** ![Jayden](https://avatars.discourse-cdn.com/v4/letter/j/db5fbb/32.png) [@Jayden](https://forum.inductiveautomation.com/u/Jayden)\ **Post date:** [May 6, 2022, 9:15am UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/5 "2022-05-06T09:15:04Z")
Thanks Jonathan, I’ll check these settings, I don’t think it gave me an option to select Firebird as the default translator. I’ll check again. Jayden ---
**Author:** ![MTekin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mtekin/32/50257_2.png) [@MTekin](https://forum.inductiveautomation.com/u/MTekin)\ **Post date:** [October 13, 2023, 5:14pm UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/6 "2023-10-13T17:14:45Z")
For posterity, I found that I was getting 'Dynamic SQL error -104. Unexpected end of command" when trying to connect. And I needed to change the default validation query in the driver settings from 'SELECT 1' to 'SELECT \* FROM RDB$RELATIONS' to establish a connection. I got that query from this page: [Working with databases](https://firebirdsql.org/manual/qsg15-databases.html#qsg15-databases-creating) ---
**Author:** ![BVTV](https://avatars.discourse-cdn.com/v4/letter/b/e5b9ba/32.png) [@BVTV](https://forum.inductiveautomation.com/u/BVTV)\ **Post date:** [February 1, 2024, 8:24am UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/7 "2024-02-01T08:24:55Z")
Thanks, Exactly what I needed! For testing, I connected to the built in demo database in firebird: jdbc:firebirdsql://localhost:3050/employee Anywhere I can get the information I need for creating a firebird translator in Ignition? I have only filled out two fields in my translator so far: Limit Syntax = FIRST {limit} Limit Position = Front ---
**Author:** ![MUNIYANDI\_D](https://avatars.discourse-cdn.com/v4/letter/m/48db29/32.png) [@MUNIYANDI\_D](https://forum.inductiveautomation.com/u/MUNIYANDI_D)\ **Post date:** [January 6, 2025, 12:02pm UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/8 "2025-01-06T12:02:37Z")
Hi @jonathan.taylor and Everyone, ``` I'm trying to connect the Firebird db to ignition. But, that was showing faulted in the Status of the Database. ``` Drivers and URL links are also given, as you mentioned. I'll give an images of the driver and Db config page below. Driver Config : ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/d/ad043a1f3f95fb3b649716d3e2c79ad9f5961bb2.png) I've given the image of the Jar\* file I used in the driver configuration. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/15c980eadea2e8d88852acfccdec9c20fab8193b.png) Database Config: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/d/9d6ab523afddf407a351da9f23ea533709e153cc.png) Status: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/8/c8b5f6889e35b01e7f8907e46ce4c1466ede30f8.png) I have given the MSSQL to the translator for the advanced properties of the DB configuration. Could anyone give me an idea or any suggestions for connecting the Firebird db? Thanks and Regard, Muniyandi D ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 6, 2025, 12:44pm UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241/9 "2025-01-06T12:44:54Z")
When the connection faults, there should be a detailed log entry with more information. Look for that.