On 18 Feb 2002, at 21:06, perryj313 wrote:

> --- 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.
> >

Delphi 6 doesn't have a way of accessing ODBC? They used to...

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