--- In ib-support@y..., "Paul Schmidt" <paul@t...> wrote:

> 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@t...
> www.tricattechnologies.com

OK, then, what set of components do I use to get access to ODBC?