On 18 Feb 2002, at 18:08, perryj313 wrote:

> We recently converted our app from BDE to ADO so we could connect to
> MS/SQL and Interbase. The MS/SQL connection is working great. My
> problem is that I can not find an Interbase OLE/DB Provider that will
> work. Our app is data entry and reporting programs written in Delphi
> 6 and is built around data-aware components. All data access
> components are TADOQuery and TwwDataSource. I have tried EasySoft
> ODBC and that seems slower than BDE. I have tried OLEDB.Net, Free
> IBProvider, SIBProvider and ZStyle IB Provider each of them have
> various problems. They all seem to be written for read only access.
> Can you suggest the best method to connect to Interbase using ADO?
> Or, tell me that it is hopeless and to go with Interbase specific data
> access components.
>

If you need to support various DBs then ODBC is the way to go,
forget ADO, I looked at it one point, and it basically simply adds
another layer of complexity. The fastest access will be native
mode, the API will always be the most flexible and fastest, libraries
like IBO, FIBPlus and IBX are not far behind, although you have to
be careful with IBX, in that the developer has said that Firebird
specific features will not be implemented by Interbase specific
ones will be. Emulator layers like ODBC, BDE etc will always be
slower still, but ADO has to convert calls into ODBC calls and
ODBC converts them into native mode calls, so it will be slower
still.

Paul



Paul Schmidt
Tricat Technologies
paul@...
www.tricattechnologies.com