Subject Re: [firebird-support] Firebird, dialects and JDBC
Author Lester Caine
> I'm trying to set up Firebird databases against ColdFusion MX 6.1, and
> seem to have great difficulty in setting up a JDBC driver that works with
> CF's stored procedure mechanism. I've tried Jaybird, which won't work, and
> have just treid setting up InterClient (an older version), which tells me
> I needd something other than Dialect 1. So.... I created a new .fdb using
> dialect 3, and the same Interclient said it did not support this, so
> presumably there was a Dialect 2 somewhere along the way (I'm also new to
> Firebird, as if that wasn't obvious <g>).
>
> Am I going to get similar results if I use the latest version 2
> Interclient? Do I have to have dialect 3 to work with the latest
> InterClient? Is there another JDBC driver (preferably free?) that works
> with CFMX properly? Would I be better off using a good ODBC driver (like
> Easysoft) and using CF's ODBC Socket connection?
>
> Sorry for so many (perhaps OT) questions, but I'm starting to get
> desperate, so any hints would be welcomed.

What were the problems with Jaybird?
If you take them to the Firebird-Java list, then they may
well be able to sort you out. The programmers hang out there :)

Jaybird works fine for me when I use it from various java
type packages.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services