Subject Re: [ib-support] Re: Firebird and the BDE/SQL Links
Author Frank Schlottmann-Goedde
Jeff Shoaf schrieb:

> The valid reasons... When we started using Paradox, it was still a
> vibrant Borland product. It wasn't a corporate standard, but the
> corporate standard (Access - yuck!) didn't meet our needs. Over the
> years, we've come to the point that we're using Paradox to run our
> departments business - to the point that we hired an additional Paradox
> programmer to provide backup.
>
> Now I've ran into some things that Paradox alone can't handle, but
> Paradox and a C/S database can. My fellow Paradox developers don't
> believe that - they feel that if it can't be done in Paradox, we
> shouldn't even be doing it! By migrating to a C/S backend, I'm trying to
> ease into transitioning away from Paradox and if Paradox and/or the BDE
> stop working due to OS changes, we'll be better prepared to change just
> the front-end.

We are in the process of changing the back-end of all our applications
(they are all BDE-based with either dBase or Paradox databases) to
Firebird at the moment. It is working nearly painless :-)

Take a look at http://www.geocities.com/poloziouk/IBDataPump.html for a
fantastic tool to convert your old paradox data to Firebird.

Set SQLQRYMODE to SERVER and you can even use the new features of
Firebird (select first ...)

> The company I work for is buying into MS's .Net stuff in a big way.

There should be a .NET provider for Firebird really soon now.

> We
> are looking at moving to C# or VB.Net, but we have immediate needs that
> can't wait for me to learn something else - I'm looking to have this app
> up and running by mid-December. I can do that (well, without
> documentation) using Paradox and IB, but not something else.

Should be possible. Stay with Firebird 1.0 for the moment (it probably
has all features you will need the next months), use the firebird client
library (gds32.dll) where possible and use BDE Version 5.01 as it has
dialect 3 enabled.


good luck


--
mit freundlichen Grüssen
Frank Schlottmann-Gödde

Martens & Prahl EDV
Wielandstr. 14c
23554 Lübeck

Tel.: 0451/39904-555