Re: Word to Oracle via VBA

From: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Tue, 8 Apr 2003 15:48:35 -0700
Message-ID: <UDCdnSO38pxezA6jXTWcqg@giganews.com>

> Isn't OLEDB the "successor" to OO4OLE? I thought it was.

Maybe, but not a "replacement." oo4o is Oracle's own access library, and it does not necessarily follow any standard. It's just an OCX component one can talk to. ODBC, OLEDB, and now .NET Data Providers _are_ standards, and Oracle drivers for those data access methods do follow the standard interface.

In other words, oo4o was created non-standard because the existing data access methods were too simple back then. Now with the better access methods and more mature drivers in existance, it really makes little sense to depart from the established standards and so Oracle is back to producing drivers (as opposed to competing, non-standard libraries).

Anyway, it looks like oo4o is still alive and kicking, although I would certainly not start a new project with it.

> no need for anything other than ODBC, at least in Excel. I've got
> OO4OLE installed as well, but it's an old thing.

Well it still comes with the 9iR2 client and it looks recently updated. Received on Tue Apr 08 2003 - 17:48:35 CDT