Re: Oracle Components for OLE versus OCI

From: Maddalena Capp <Maddalena.Capp_at_btopenworld.com>
Date: Sat, 9 Feb 2002 09:17:36 +0000 (UTC)
Message-ID: <a42pff$gt1$1_at_paris.btinternet.com>


I've used oo4o more than OCI. The applications I've developed have been in MSVC++ 6.0. I agree with Jim that oo4o is easy to use. Additionally, the ability to positioned updates with oo4o is great.

However, one thing to watch out for is the target system the software will be installed on. Each version of the Oracle client seems to be bundled with a different version of the oo4o DLLs (ORACLM.DLL / ORACLM32.DLL). The application code must be linked to the correct library for that version in order for it to run.

OCI (8 anyway) is backwards compatible. But as already stated is difficult to use. You may may like to look at the "Oracle C++ LIbrary" from www.crlab.com for an alternative. This is a C++ wrapper to the OCI and works with Oracle 7 & 8. However, it's not capable of doing positioned updates.

Hope this helps.

Adrian

"Roy" <something_at_something.here> wrote in message news:a3u0lv$gv6$1_at_news1.xs4all.nl...
> Hi,
>
> At this moment we are making components using OCI and Oracle Components
for
> MTS on a Windows2000 application server and all seems to work fine.
>
> However a new colleague says that we could better use OO4O because it's
> easier to programme with.
>
> Does somebody have some experience with the 2 methods and give some reason
> to use the one or the other?
>
> Thanks for the info,
> Roy
>
>
Received on Sat Feb 09 2002 - 10:17:36 CET

Original text of this message