In the CF Administrator Select Datasources
Settings are as follows :

JDBC URL
jdbc:firebirdsql://ServerName/c:\DatabaseFolder\Database\DatabaseName.GDB
Driver Class org.firebirdsql.jdbc.FBDrive

Administrator Server Settings Java and JML : Firebird,"
c:\Coldfusion8\wwwroot\WEB-INF\Classes"
Make sure the file jaybird-full-2.1.1.jar located at
c:\Coldfusion8\wwwroot\WEB-INF\Classes or alternatively in the directory
in place of the above.

The last step is the one that tricked me. Seems the call by CF is case
sensitive. I went around in circles before getting it right.

I hope this helps.

Mike



red_october2009 wrote:

>
>
> Development Environment:
>
> XP Pro, ColdFusion Builder 1, on ColdFusion 9, Firebird RDBMS 2.1.2
>
> I was able to connect CFB1 to Firebird 2x using ODBC in the
> development view. It appears in the RDS View. However, when I try to
> run my project, an error is thrown by Hibernate, saying that it needs
> the proper Dialect. Problem: I don't know how to configure Hibernate
> to tell it that the Dialect should be 3. (In the ODBC connection I
> already state this, but, Hibernate doesn't read that setting.)
>
> So, I obtained the file: Jaybird-2.1.6JDK_1.6.zip
> Thinking I would just connect the JDBC way. Problem: I've never done
> this before and don't know how to do it.
>
> I've read the install/helps on all the products involved and either
> the help is full of acronyms that aren't explained and expert level
> gobbely-gook, or the instructions don't seem to exist.
>
> Is there some kind should who can explain, at the "beginer" or "For
> Dummies" level, exactly how to tell ColdFusion Builder 1 (Which is the
> latest version) to use Firebird 2.1.2 as the DB?
>
> (King of like:
> 1) Unzip the jaybird file
> 2) Place the unzipped contents in folder: ?
> 3) Configure your Jaybird to talke to your FB DB by editing file..?
> 4) In ColdFusion "Administrator" click menu choices .?./..?
> 5) In ColdFusion Builder, click menu choices ../..? ?
> )
>
> Thanks in advance.
>
>

[Non-text portions of this message have been removed]