SQL Server Performance Forum – Threads Archive
ODBC and OLE DB
What kinds of applications are good to use ODBC data accessand what kinds of applications are good to use OLE DB data access? please give me some examples and deep explanation. Thanks in advance
——————
Bug explorer/finder/seeker/locator
——————
With the advent of ADO.NET and SQL Server 2005, choosing between ODBC and OLEDB is no longer the question. If you are using a programming language (environment) for your front-end application that does NOT support ADO.NET (or the System.Data.SqlClient namespace specifically), you may find that your fallback options will be ADO (on OLEDB) and then ODBC in that order. The choice is usually dependant on the availability of an OLEDB provider or ODBC driver for the back-end database. But if your question is more academic than contemporary (or practical), you may find these articles useful: 1.http://www.dbmsmag.com/9604d53.html
2.http://en.wikipedia.org/wiki/Open_Database_Connectivity
Nathan H. Omukwenyi
MVP [SQL Server]
]]>