Re: ODBC or OLE DB

There is also a managed MySQL Data provider that works very well.


"Shawn Wildermuth (C# MVP)" <swildermuth@xxxxxxxxxxxxxxxx> wrote in message
news:fc24ddbd227868c8a97e1bc5a979@xxxxxxxxxxxxxxxxxxxxxxx
Hello Chris,

Generally OLE DB is preferrable because it can retrieve data a bit more
efficiently than ODBC...*but* it all depends on the quality of the
driver/provider. It is not difficult to write a badly performing OLE DB
provider that is slower than its ODBC counterpart. In general you will
also find that the Managed Providers (ADO.NET) for SQL Server and Oracle
will out perform their OLE DB/ODBC because of marshaling issues.

I know its a lot of opinion without a lot of data, but there are so many
things that can impact performance, usually the provider of the data is
just one of a number of possible cause of performance issues.
Thanks,
Shawn Wildermuth
Speaker, Author and C# MVP
http://adoguy.com

Hi,

Thanks for the reply, but do you know if there is a document where
they compare response times etc?

Regards

Chris

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote
in message news:O2O9Vss2GHA.1304@xxxxxxxxxxxxxxxxxxxxxxx

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

  • Re: Samplclnt example in MDAC 2.8: My Story
    ... I was incorrect when I stated that ODBC as a whole is deprecated. ... ODBC provider for OLE DB is deprecated; ... > | compiler errors. ...
    (microsoft.public.data.oledb)
  • Re: Word 2007 mailmerge
    ... Word is trying to connect using the OLE DB provider ... it either fails because that provider is not present or because the table name is in the wrong format for the provider. ... (this is what Word generates when you try to connect manually using ODBC) ... on Vista, the default folder for Data Sources is now some kind of "search folder" that does not appear to pick up data sources recently saved in the former default folder, i.e. the user's My Data Sources folder ...
    (microsoft.public.word.vba.general)
  • OLE DB Provider for ODBC and Oracle
    ... I created a linked server for MS SQL Server 2005 Express to an Oracle ... database using the OLE DB Provider for ODBC. ... I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB ...
    (comp.databases.ms-sqlserver)
  • Re: Is there any (free!) ADO - OLE DB Provider for Lotus Notes?
    ... I know that I can use OLE DB Provider for ODBC and then use OBCD ... So....is there any OLE DB Provider for Lotus Notes??? ...
    (microsoft.public.data.ado)
  • Re: OLE DB Provider for ODBC/Win XP
    ... The Data Sources (ODBC) control panel applet only deals with ODBC data ... You are referring to an OLE DB provider. ... OLE DB has a similar data sources interface. ...
    (microsoft.public.sqlserver.odbc)