ole-db vs odbc

J O Holloway

Delphi Developer

Sat, 26 Jul 2003 03:08:02 GMT

ado/ole-db vs odbc

I have seen a couple of threads recommending OLE-DB over ODBC, but none
explaining why (at least, I did not find any). Would anyone be willing to
explain exactly why OLE-DB is better than ODBC? Can anyone give specific
quantitative reasons why they judge OLE-DB to be better/faster/stronger than
ODBC?

As a side-note, I use SQL Server and DB2, accessing data from both Windows
and Web front-ends. We also will be bringing Oracle in soon.

Thanks for your time.

Londonbab

Delphi Developer

Sun, 27 Jul 2003 19:48:34 GMT

Re:ado/ole-db vs odbc

The theory is that OLE-DB uses native drivers, and is therefore faster - in my
experience this seems to be true, especially with Access and Oracle.
Niall

Quote

J O Holloway wrote:
> I have seen a couple of threads recommending OLE-DB over ODBC, but none
> explaining why (at least, I did not find any). Would anyone be willing to
> explain exactly why OLE-DB is better than ODBC? Can anyone give specific
> quantitative reasons why they judge OLE-DB to be better/faster/stronger than
> ODBC?

> As a side-note, I use SQL Server and DB2, accessing data from both Windows
> and Web front-ends. We also will be bringing Oracle in soon.

> Thanks for your time.

Other Threads

1. OLE DB Provider for ODBC OR Microsoft Jet 4.0 Ole DB Provider

2. ADO-OLE DB-ODBC OPINIONS WANTED!!!!!

3. Microsoft Jet 4.0 OLE Provider vs OLE Provider for ODBC

4. ado vs idapi vs odbc

5. ADO ODBC vs dbExpress ODBC

6. ADO ODBC vs DBExpress ODBC

7. TRemoteServer vs OLE DB

8. MS OLE DB Providers for ODBC and SQL Server

9. Problems with OLE DB Provider for ODBC Drivers

10. Writing OLE DB (ODBC) Provider with Delphi