On 22 Feb 2002, at 0:11, Nataraj S Narayanan wrote:

> On Mon, 18 Feb 2002, Paul Schmidt 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
>
> > 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
>
> How much do these cost? Our exchange rate in India is a killer -
> Rupees 45 for 1$. Which of these - IBO,FIBPlus or any other native IB
> ones - are economical?

Gee and I thought the Loonie was bad enough (Actually a dollar
valued at USD $0.62, has meant the current economic problems
have not hit here as hard). For native Access IBO is the best, it's
not the cheapest, but CPS is fairly flexible with their licence and
the way people pay for that licence. However If you maintain
versions for different databases, then you want to maintain as
much of the same code base as possible, otherwise maintenance
gets to be a real pain in the mule, because your maintaining
multiple copies of the same code.

> I want to convert a medical store software that has been deployed over
> 110 shops in my place. The sad thing is that it was done in premitive
> Delphi 1.0 (16 bit) and the BDe that came with D1. The sadder thing is
> that I am entrusted to maintain the Interbase database, but don'nt
> have the source code of Delphi prog.
>
>
> I know the following is next to impossible.
>
> Is there a way to hack out the BDE and use IBO instead without
> recompilation ?
>

No.

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