ODBCExpress. It is the best third party ODBC Dataset.

--- In ib-support@y..., Perry Jacobs <perryj313@y...> wrote:
>
> --- Paul Schmidt <paul@t...> 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@t...
> > 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