Alvaro, I'm using VFP 7.0 as frontend for a Firebird 1.02 database on
three different applications. Two of them running since about one
year ago.

For accesing database I go Gemini 2.1. Can't tell you about the other
drivers because it was my boss who tested them, but this is the one
he had chosen.

About the use of firebird with VFP there's not much I can tell you
about because i'm pretty new, not only to firebird, but to RDMS's
(I'm working here since last November). One of the things it cause me
some trubles is migrating dbf's. Be carefull when managing views (set
VFP views properties to the best, don't use them as default).

I wouldn't borrie about the engine: It is great and works great. And
i'm sure version 1.5 final will be ever greater....

regards,

Pablo Lerner

--- In firebird-support@yahoogroups.com, "Alvaro Jimenez" <afj@a...>
wrote:

> Hello all
>
> I'm evaluating the feasibility of migrating to Firebird a Visual

FoxPro 6

> application that stores data in VFP's native DBF (DBC) format but

access it

> via ODBC. So far, I've found four ODBC drivers: IBPhoenix Open

Source (which

> I believe is for Java only??) and XTG ODBC Driver (which crashes

everytime).

> I still have to try EasySoft Interbase and Gemini ODBC. Since

nobody in the

> VFP community (that I'm aware of) is going this way, I don't know

which

> version would be best for my app. I already migrated it to SQL

Server 7 and

> works well, but there're some unexplained (unexplainable?) errors,
> non-repetable and rare: connection hang-ups, spurious data, need to

reboot

> server, etc. But really, for the price, either there should be no

errors or

> should be promptly fixed by you-know-who.
>
> So, I'm asking for any help and comments here: Is anybody using

sucessfully

> Visual FoxPro 6 programs with FB 1.03 via ODBC? What problems did

you found?

> Which ODBC driver works best for stability and speed? What OS is

your FB

> server on, Windows or Linux?
>
> Of course I'll do my own tests, but since I'm quite, quite new to

FB, I'll

> probably make an error and mistake it for a real problem. Please

don't think

> I'm lazy ;_;
>
> Thank you very much