At 10:20 AM 30/10/2003 +0000, you wrote:

>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.

Well, as a first measure, JOIN THE RIGHT
GROUP. www.yahoogroups.com/groups/firebird-java

And no, there is no such thing as a Dialect 2 database. You would get an
error vaguely like the one you describe if you try to connect a Dialect 3
client to a Dialect 1 database or vice versa.

Forget InterClient. Dead.

heLen