# Attempting to Connect to a Firebird Database

**URL:** <https://forum.inductiveautomation.com/t/attempting-to-connect-to-a-firebird-database/110792>\
**Category:** Ignition\
**Created:** [September 19, 2025, 4:57pm UTC](https://forum.inductiveautomation.com/t/attempting-to-connect-to-a-firebird-database/110792 "2025-09-19T16:57:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![aircapital.engineer](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aircapital.engineer](https://forum.inductiveautomation.com/u/aircapital.engineer)\
**Post date:** [September 19, 2025, 4:57pm UTC](https://forum.inductiveautomation.com/t/attempting-to-connect-to-a-firebird-database/110792/1 "2025-09-19T16:57:36Z")

</div>

I have created a local Firebird database. That database is located at D:\firebirdtest\TEST.FDB. I added the Firebird driver, provided the correct .jar file, and then I created a database connection with the connect URL as ‘D:\firebirdtest\TEST.FDB’. The database then appears with an ERROR status, reading “Cannot create JDBC driver of class ‘org.firebirdsql.jdbc.FBDriver’ for connect URL ‘D:\firebirdtest\test.fdb'“.

I’ve attempted other connect URL’s and get a connection-based error, leading me to believe that I may have set up the driver wrong, but I am open to other possibilities. Still learning to use Ignition and would very much appreciate some help.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 19, 2025, 5:00pm UTC](https://forum.inductiveautomation.com/t/attempting-to-connect-to-a-firebird-database/110792/2 "2025-09-19T17:00:04Z")

</div>

Your new database connection is set up to use the Firebird JDBC driver profile you set up, correct? What's the status of that JDBC driver you added?

---

<div class="post-metadata">

**Author:** ![aircapital.engineer](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aircapital.engineer](https://forum.inductiveautomation.com/u/aircapital.engineer)\
**Post date:** [September 19, 2025, 5:04pm UTC](https://forum.inductiveautomation.com/t/attempting-to-connect-to-a-firebird-database/110792/3 "2025-09-19T17:04:36Z")

</div>

The status on the Firebird driver is “Installed”. The database connection is set to use the Firebird driver.

---

<div class="post-metadata">

**Author:** ![aircapital.engineer](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aircapital.engineer](https://forum.inductiveautomation.com/u/aircapital.engineer)\
**Post date:** [September 23, 2025, 5:10pm UTC](https://forum.inductiveautomation.com/t/attempting-to-connect-to-a-firebird-database/110792/4 "2025-09-23T17:10:56Z")

</div>

I believe I’ve sorted the driver/connect URL issues, but am now getting the following error:

Dynamic SQL Error; SQL error code = -104; Unexpected end of command - line 1, column 8 [SQLState:42000, ISC error code:335544851]

With the highlighted error line being:

at com.inductiveautomation.ignition.gateway.datasource.DelegatingStatement.executeQuery(DelegatingStatement.java:64)

---

<div class="post-metadata">

**Author:** ![aircapital.engineer](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aircapital.engineer](https://forum.inductiveautomation.com/u/aircapital.engineer)\
**Post date:** [October 1, 2025, 12:50pm UTC](https://forum.inductiveautomation.com/t/attempting-to-connect-to-a-firebird-database/110792/5 "2025-10-01T12:50:52Z")

</div>

We were able to get Firebird working with these settings on the translator and driver, big thank you to John Saunders from Inductive Automation for helping out.

_Translator_

Create Table Syntax: CREATE TABLE {tablename} ({creationdef}{primarykeydef})

Create Sequence Syntax: CREATE GENERATOR {tablename}\_ID

Create Trigger Syntax: CREATE TRIGGER {tablename}\_trigger FOR {tablename}

Create Index Syntax: CREATE INDEX {indexname} ON {tablename}({columnname})

Auto Increment Field Definition: {type} NOT NULL AUTO\_INCREMENT

Alter Table Syntax: ALTER TABLE {tablename} {alterdef}

Add Column Syntax: ADD COLUMN {columnname} {type}

Primary Key Syntax: PRIMARY KEY ({columnname})

Limit Syntax: LIMIT {limit}

Limit Position: Front

Current Timestamp Query: SELECT CURRENT\_TIMESTAMP FROM rdb$database

Column Quote Character: “

Fetch Key Query: SELECT max{{columnname}} FROM {tablename}

_Driver_

Classname: org.firebirdsql.jdbc.FBDriver

JAR file: jaybird-6.0.3.jar or equivalent

Driver Type: Firebird

URL format: jdbc:firebirdsql:10.1.1.1[/port]:/path/to/db.fdb

Default Validation Query: SELECT 1 FROM rdb$database

Default Translator: FIREBIRD