ODBC or OLE DB

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

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@email.com> wrote in message
news:450df606$0$7315$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> 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
>

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@comcast.netNoSpamM> wrote in
message news:O2O9Vss2GHA.1304@TK2MSFTNGP05.phx.gbl...
> 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@email.com> wrote in message
> news:450df606$0$7315$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
>> 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
>>
>
>

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@comcast.netNoSpamM> wrote
> in message news:O2O9Vss2GHA.1304@TK2MSFTNGP05.phx.gbl...
>
>> 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@email.com> wrote in message
>> news:450df606$0$7315$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
>>
>>> 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
>>>

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


"Shawn Wildermuth (C# MVP)" <swildermuth@newsgroup.nospam> wrote in message
news:fc24ddbd227868c8a97e1bc5a979@msnews.microsoft.com...
> 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@comcast.netNoSpamM> wrote
>> in message news:O2O9Vss2GHA.1304@TK2MSFTNGP05.phx.gbl...
>>
>>> 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@email.com> wrote in message
>>> news:450df606$0$7315$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
>>>
>>>> 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
>>>>
>
>