Thanks for the tips, Helen.

Cheers
Terry

----------Original Message---------

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