CF7 and Firebird Database setup

[creep80209]

Ok... Have read and re-read the postings about how to connect Firebird to CF
server. Cannot get it to work. Can someone help me step by step?

I have a Firebird file on machine (192.168.10.173), which is part of a Desktop
application that needs to submit information to an Intranet. I have a drive
share to the file (H drive). I need to connect it to my CF server
(192.168.10.179). I downloaded FirebirdSQL-1.5.5JDK_1.3.zip and placed the
firebirdsql-full.jar in C:\CFusionMX7\lib\.

I went into the CF administrator section "Data Sources". Typed "TestDB" as the
Data Source Name and Driver as "Other".
Made JDBC URL = "jdbc:firebirdsql://192.168.10.173:3050:C:\HMS\HMSUSER.DB",
Driver Class = "org.firebirdsql.jdbc.FBDriver", Driver Name =
"C:\CFusionMX7\lib\firebirdsql.jar", and specified the Username and password of
the database.

When I submit the information I get:

Connection verification failed for data source: testDB
java.sql.SQLException: No suitable driver available for testDB, please
check the driver setting in
resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver
available for testDB, please check the
driver setting in resources file, error: null

I would say that the JAR file is not installed correctly or the Host machine
is not setup to broadcast as server.

[chasAFD]

Here's my setup that works fine (Win2003 servers):
JDBC URL: jdbc:firebirdsql:FB_sql/3050:d:\\db_mypath\MyFBdatabase.gdb
Driver Class: org.firebirdsql.jdbc.FBDriver
Driver Name: org.firebirdsql.jdbc.FBDriver

In the URL, "FB_sql" is the name of the Firebird server, d:\\db_mypath is the
path from the server's perspective (D: is on FB_sql server). In CF
Administrator, under heading "Java and JVM", set the Class Path to point to the
jar file, relative to the CFMX server. Stop and restart the CFMX service
anytime you change the class path.

BTW, if you're looking for a good Firebird admin tool, check out DBworkbench
from [url]www.upscene.com[/url]. Not free, but cheap, and well worth the small price.

(If you see an emoticon, it should read "...3050" colon "d" colon backslash
backslash mypath backslash myDB.gdb)
Good luck! I've had great success with CF <--> ODBC <--> Firebird and now
CFMX <--> Jaybird JDBC <--> Firebird