Quoting Kerry Sainsbury <[EMAIL PROTECTED]>:
> *********** REPLY SEPARATOR ***********
>
> On 1/09/99 at 23:27 Nic Wise wrote:
>
> >> Tony Blomfield wrote:
> >>
> >> 1. For Interbase we have FIB and IBO
> >>
> >> 2. For Oracle we have ODA ?? Components.
> >
> >DOA, I beleive.... :) Direct Oracle Access. Supposed to be quite good.
> >
> >> Does anybody know of similar components for working with the Database
> >> API for SQL Server 7, and Informix?
> >
> >SS - OLEDB or ODBC is the only 'supported' method - use ADO, as most
> >users have it now. Better yet, get Delphi 5 - the enterprise version has
> >it built in (and its an 'upsell' on the pro - marketing speak, gotta
> >love it)
> >
> >As for Informix - KERRY!!!!!
>
> Nothing I've heard about, sorry.
Informix has OLE DB capability. Here is an extract from
http://www.microsoft.com/data/ado/sigmod98.htm
"To date, there are OLE DB providers for most commercial relational DBMSs
including Oracle, Microsoft® SQL Server™, IBM DB2, Sybase, Informix, CA-Ingres,
and ODBC sources. In addition, there are providers for VSAM, AS-400 files,
IMS/DB, and Windows NT® files via a content search engine. OLE DB has recently
been extended to other domains such as OLAP, and spatial data. There are
distributed query processors over OLE DB data from International Software
Group, B2Systems, Intersolv, and Microsoft SQL Server."
Last sentence:
"OLE DB, ADO, and all services described here are part of the Microsoft Data
Access 2.0 Components. "
So if something is OLE DB capable then it is apparently a short step from there
to ADO which of course means the BDE is bypassed.
===============
Patrick Dunford
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
