--- Paul Schmidt <paul@...> wrote:

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

So what is the best way to access ODBC in Delphi 6?


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com