We have several users that are demanding MS/SQL so we
converted our app from BDE to ADO under the advise of
Borland. Then, becuase we still have clients using
Interbase, we tried connecting to Interbase with the
same programs using ODBC under ADO and the performance
was worse than the BDE. So we began looking for ADO
Providers for Interbase and found problems with all of
them.
The only choices I see now are to use a product like
SQLDirect or to have two sets of components on every
form, one for ADO and one for Interbase (probably
IBObjects). It is not practical for all of our
clients to upgrade to MS/SQL.
There must be others out there who have multi-database
applications without multiple sets of source.

Thanks,
Perry Jacobs
Shared Logic Group

--- "Claudio Valderrama C." <cvalde@...> wrote:

> ""Ann W. Harrison"" <aharrison@...> wrote
> in message
>

news:5.1.0.14.2.20020308084857.0207ede0@......

> > I got this and can't answer, being more an
> internals
> > sort of gal. Any suggestions?
> >
> > Ann
> >
> >
> > >From: Steve <Steve@...>
> > >To: "'aharrison@...'"
> <aharrison@...>
> > >Subject: ADO/Ole DB interface
> > >Date: Thu, 7 Mar 2002 21:15:05 -0500
> > >X-Mailer: Internet Mail Service (5.5.2650.21)
> > >
> > >Hi, Ann.
> > >
> > >My technicians have been struggling with Delphi6
> and Interbase after
> > >upgrading our 575+ unit application to ADO/OleDB
> and MS SQL Server.
>
> Whoa! Can anybody understand those fuzzy sentences?
> They are upgrading to
> MsSql, where's the role for IB here? Why people
> assume one has to figure out
> in a crystal ball what the heck are they doing or
> trying to do? Is he
> leaving IB and only wants to port the data to MsSql?
> Is he tired of MsSql
> and wants to come to IB? The paragraph that follows
> only says that he has
> interests in a OLE/DB provider.
>
>
> > Can't
> > >locate a usable OleDB interface for Interbase
> (They have tried several,
> > >but can't get them to work,
>
> What kind if technicians do you have, is my first
> question for him, Ann.
> :-)
> I've worked with the Brazilian OLE/DB and the
> Russian OLE/DB. There's
> another at oledb.com (or was it .org?) that I never
> have tried. Personally,
> the Russian OLE/DB worked well once I got the
> connection parameters that
> best suit my needs. And answers not addressed in the
> FAQ were sent in hours,
> even with the language impedance drawback.
>
> > or support is unavailable)
>
> Probably he's referring to the Brazilian one.
> Support requests take a lot of
> time to be answered, I know.
>
> and can't get the
> > >performance we require out of Interbase/ADO/ODBC.
>
> I don't think the driver is the culprit here. If
> he's trying to use IB as
> MsSql, no surprise. Try to use MsSql with repeatable
> read for all client
> applications and see how MsSql eventually dies after
> some time. The short
> answer is that without knowledge, it's difficult to
> expect the same from
> engines A, B & C. I think that company will have the
> same problems with IBX,
> FibPlus or IBO or the two most remarkable ODBC
> offerings, Gemini and
> EasySoft (I prefer Gemini, but that's me.)
>
>
> > >Can your organization help with sourcing an OleDB
> provider that is
> > >functionally equivalent to that use with MS SQL
> Server, but for
> Interbase?
>
> I understand he's asking for a bloated OLE/DB
> provider that will provide all
> nasty *bonus* services that the MsSql provider for
> OLE/DB has. Who would
> want this? Worse, who would fund this, Shared Logic?
> I think that the
> request may be well intentioned, but it's out of
> context. We can't mimic
> MsSql. For example, I know the Russian OLE/DB driver
> is enough fast for a
> web server (I've tested it) but if all drivers were
> found too slow, I'm
> inclined to think that the problem is in the queries
> that are sent to the
> engine.
>
> It's impossible to suggest more without knowing what
> the person/company is
> doing and what are their concrete problems, sorry.
>
> C.
> --
> Claudio Valderrama C. - http://www.cvalde.com -
> http://www.firebirdSql.org
> Independent developer
> Owner of the Interbase� WebRing
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/