Attempting to Connect to a Firebird Database

Ignition
1

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.

2

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?

3

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

4

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)