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.

Cheers
Terry Riley