Hi Steve,

> I have a simple question to ask just to see if anyone else is doing this
> or knows about whether or not I should do it...
>
> We currently have 40 or so Firebird 1.5 Dialect 1 databases running on
> linux (CentOS and Firebird Classic). This was a migration from
> Interbase 5.6 with one of the software clients being written in Delphi 7
> over the BDE and another software client being written in java over
> InterClient. Now it is still using Delphi 7 over the BDE, but the java
> stuff has been converted to use JayBird. Our eventual goal is to move
> to Firebird 2.1 (when it is released to production), use Dialect 3, and
> get rid of the BDE. However, I was thinking of doing it one step at a
> time to cut down on the number of changes which should hopefully cut
> down on the amount of things that could go wrong.
>
> Anyways, my questions are:
>
> 1) Is anyone using the BDE with Firebird 2?
> 2) Does the BDE work with Dialect 3 databases?
> 3) Is anyone using Dialect 1 with Firebird 2?

Hold you horses, changing the dialect isn't the only problem you can
encounter during Fb 1.5 to 2.1 ...

For example, if your queries are being slightly mis-written with regard
to aliassing, they will be rejected by Firebird 2.

And yes, I believe you can use the BDE with dialect 3 if you change a
key in the registry.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com