I’m trying to connect to an existing Firebird database with Lucee 5.3.7.47 on Windows 10.
I’ve tried creating a datasource and defining it in the Application.cfc with zero luck.
I can connect to MS SQL and My SQL fine. I’ve put the JAR files in Lucee for Firebird.
Here’s the connection string (it works in several other apps):
jdbc:firebirdsql://hub:3050/D:\SiteWatch\DB\SiteWatch.FDB
And the code in Application.cfc:
this.datasources["drb"] = {
class: 'org.firebirdsql.jdbc.FBDriver'
, connectionString: 'jdbc:firebirdsql://hub:3050/D$\SiteWatch\DB'
, username: 'REPORTS'
, password: "******"
// optional settings
, connectionLimit:100 // default:-1
, validate:false // default: false
}
If anyone can help I would greatly appreciate it. I’ve lost days trying to connect to this db with Lucee.