| Subject | Re: [ib-support] Fwd: ADO/Ole DB interface |
|---|---|
| Author | Claudio Valderrama C. |
| Post date | 2002-03-11T08:04:37Z |
""Ann W. Harrison"" <aharrison@...> wrote in message
news:5.1.0.14.2.20020308084857.0207ede0@......
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.
:-)
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.
time to be answered, I know.
and can't get the
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.)
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
news:5.1.0.14.2.20020308084857.0207ede0@......
> I got this and can't answer, being more an internalsWhoa! Can anybody understand those fuzzy sentences? They are upgrading to
> 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.
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'tWhat kind if technicians do you have, is my first question for him, Ann.
> >locate a usable OleDB interface for Interbase (They have tried several,
> >but can't get them to work,
:-)
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 isInterbase?
> >functionally equivalent to that use with MS SQL Server, but for
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