 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / ADO.NET / September 2006ODBC 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).  SignatureGregory A. Beamer MVP; MCP: +I, SE, SD, DBA ************************************************* Think outside of the box! ************************************************* > Hi, > [quoted text clipped - 10 lines] > > Chris Hi, Thanks for the reply, but do you know if there is a document where they compare response times etc? Regards 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 [quoted text clipped - 15 lines] >> >> 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, > [quoted text clipped - 29 lines] >>> >>> Chris There is also a managed MySQL Data provider that works very well. > Hello Chris, > [quoted text clipped - 46 lines] >>>> >>>> Chris Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.