December 3, 2003 at 9:24 am
WHat's the Difference between OLEDB and ODBC??
Thanks
Kumari
December 4, 2003 at 10:53 am
ODBC is Open Data Base Connectivity, which is a connection method to data sources and other things. It requires that you set up a data source, or what's called a DSN using an SQL driver or other driver if connecting to other database types. Most database systems support ODBC.
OLEDB is the successor to ODBC, a set of software components that allows some code to connect with a back end such as SQL Server, Oracle, DB2, mySQL etc. In many cases the OLEDB components offer much better performance than the older ODBC. Programmers using Microsoft languages VB, .NET etc usually use ADO or ADO+ which is really just an interface to OLEDB.
You can learn a lot more by visiting http://www.microsoft.com/data.
Francis
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply