ColdFusion MX and Firebird connection problem

[Hi There]

I'm having a problem setting up a data source connection to a firebird
database. I currently have successful connections to MySQL and a PosgreSQL
DBs, but cannot get the firebird DB to validate. I receive the following error
message upon submission in the CFMX administrator : Connection verification
failed for data source: testDB []java.sql.SQLException: No suitable driver
available for testDB, please check the driver setting in jrun-resources.xml,
error: org.firebirdsql.jdbc.FBDriver The root cause was that:
java.sql.SQLException: No suitable driver available for testDB, please check
the driver setting in jrun-resources.xml, error: org.firebirdsql.jdbc.FBDriver
I've checked and double checked the JDBC URL, driver class and the JVM class
path in my CFMX administrator to no avail: JDBC URL
jdbc:firebirdsql://db1:3050/C:\\firebird\\firebird_1_5\\data\\db\\planning.fdb
DRIVER CLASS org.firebirdsql.jdbc.FBDriver CLASS PATH
/opt/coldfusionmx/fbjdbc/firebirdsql-full.jar If the JDBC driver exists and
the path is correct it should be a simple connection to firebird, correct? I
have NOT upgraded to version 6.1 of Coldfusion MX yet. Would it be possible
that I need to have the upgrade to be able to successfully connect to
firebird??? I'm not sure what else to try...

[Eugene]

Hi,

I am using FireBird with CF MX 6.1 with all updates and all woks fine.
In CF admin I set following:
JDBC URL -- jdbc:firebirdsql:195.122.200.210:E:\DB\Game.gdb
(jdbc:firebirdsql:<server_IP>:<Full_path_at_the_se rver>)
Driver Class -- org.firebirdsql.jdbc.FBDriver

And I put file firebirdsql.jar in to the folder <cf_root>\lib\

This is all.
---
Eugene Krivenja

[Hi There]

Thanks.

I guess I'll try the 6.1 upgrade and updaters and hope it works.

[Hi There]

CFMX 6.1 upgrade and 6.1 updater didn't help. Back to square one. :disgust;

[Hi There]

Actually, the CFMX 6.1 upgrade and 6.1 updater seemed to help with CF being
able to locate the jdbc driver for firebird and the 'No suitable driver
available' error went away. Adjusting the JDBC URL was the final solution.
Using a suggestion from another forum on the web, I originally had the
following syntax: jdbc:firebirdsql://db1:3050/C:\\Firebird\\data\\db\\test.fdb
(jdbc:firebirdsql://<server>:3050/:<Full_path_at_the_server) ... which timed
out. Utilizing the above suggestion I eliminated the ':3050' and instead used:
jdbc:firebirdsql:db1:C:\Firebird\Firebird_1_5\data \db\test.fdb
(jdbc:firebirdsql:<server>:<Full_path_at_the_serve r) as suggested above. Now
the Firebird DB verifies in CFMX 6.1. Thanks!

[Eugene]

No thanks :)
If you need to set the port number, use this syntax:

jdbc:firebirdsql:db1/3050:C:\Firebird\Firebird_1_5\data\db\test.fdb
(jdbc:firebirdsql:<server>[/<port>]:<Full_path_at_the_server)

---
Eugene Krivenja