Skip to main content
Known Participant
September 21, 2009
Answered

Will adobe ColdFusion allow me to connect to Mozilla Firebird DB?

  • September 21, 2009
  • 2 replies
  • 1425 views

I'm surprised that ColdFusion will connect to Access and MySQL but not to Firebird DB.

http://www.firebirdsql.org/

Firebird is an enterprize level DB, been around as long as Oracle (in the form of Interbase, then Firebird), has full SQL standards compliance, is high performance, has all the triggers and stored procedure and other stuff MySQL doesn't have, yet it is not listed in the supported DBs of Adobe ColdFusion.

What gives?

This topic has been closed for replies.
Correct answer ilssac

Got a database driver for Firbird?  Preferably a JDBC 4 driver.

Install the driver.

Configure ColdFusion to use the custom driver.

Be the first CF user I know of to connect to this database.  I've never heard of it before.

2 replies

Known Participant
September 22, 2009

Also, during installation on my XP Pro machine, ODBC services are shown as an installable option, and Firebird has an ODBC driver, so, all is well.

ilssac
ilssacCorrect answer
Inspiring
September 21, 2009

Got a database driver for Firbird?  Preferably a JDBC 4 driver.

Install the driver.

Configure ColdFusion to use the custom driver.

Be the first CF user I know of to connect to this database.  I've never heard of it before.

Known Participant
September 22, 2009

Ian, may I present Firebird and Jaybird:

Firebird: The best DB in the world!

http://www.firebirdsql.org/

Jaybird: The JDBC 4 driver for the best DB in the world

http://www.firebirdsql.org/index.php?op=devel&sub=jdbc&id=faq#27
http://www.firebirdsql.org/index.php?op=devel&sub=jdbc
http://www.firebirdsql.org/index.php?op=files&id=jaybird

Thanks for cluing me into the correct acronym to look for "JDBC"  ... so now I can get started.