Re: ODBC or OLE DB

As long as you can find providers for each database, OLEDB is faster than
ODBC. ODBC has more options, but I believe you can find providers for all of
the databases you have listed (have not tried Ingres personally; there is an
open source driver for MySql, however).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"Chris" <chrisxxxNO_SPAM@xxxxxxxxx> wrote in message
news:450df606$0$7315$5a62ac22@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

What should I choose ODBC or OLE DB?
I need to connect to Oracle, SQLServer, Ingres and maybe MySQL.
I am not using stored procedures.

I cannot find any microsoft recomendations on there MSDN site.

Can anyone point me to some documents that have the benifits of one over
the other. i.e Performance Issues....

Thanks

Chris



.

Relevant Pages

  • WxWindows, MySQL and Windows98
    ... I'm using WxWindows to access a MySQL database on Windows98. ... I get an "ODBC parameter settings" window. ...
    (comp.programming)
  • Re: How can I connect to MySQL?
    ... Thank you so much for your recomendation of this ODBC tool. ... I'm using MySQL API to connect database under C++. ... > Click on the 'Machine Data Sources' tab of the 'Select Data Source' ...
    (microsoft.public.vc.mfc)
  • Re: OT: Alternative to IIS on Windows 2003
    ... ODBC is a database connector. ... I meant to compare MySQL with Access97 ... Are you running everything on the same box, or is the database platform ...
    (uk.rec.motorcycles)
  • Re: Access 2007: Creating a local relationship between two remote ODBC tables
    ... Relationships define how the database engine deals with the data in the ... What would be the purpose in defining relationships in the Access ... front end, since they would not be used by your ODBC data source, MySQL? ...
    (comp.databases.ms-access)
  • Problem with Import or Linked Tables with MySql
    ... I'm tried to import data from a MySQL database in to MS Access 2000. ... Also the "Test" button returns Success in the ODBC ... configuration. ...
    (microsoft.public.access.externaldata)
Loading