Understand ODBC and OLE
Understanding ODBC and OLE, there is some confusion about the relationship between ODBC and OLE. Some people have heard that the ODBC will benefit OLE, while others treat them as separate complementary technologies. This article illustrates these two technologies and how they provide access to SQL data for OLE applications. An Open Database Connection (ODBC) Open Database Connection (ODBC) technology for database connections provides a general interface for accessing different types of SQL databases. The ODBC is based on the structural query language (SQL), which uses this as a standard for accessing the data. This interface provides maximum interoperability: an application can access different SQL Database Management Systems (DBMS) via a set of public code. This allows developers to build and distribute a client / server application without at a particular DBMS. Then, the database driver will be added to link the application to the DBMS selected by the user. The following feature illustrates the flexibility of ODBC: l The application is not bound to a proprietary vendor API. l SQL statements can clearly include instantly build in the source code. l The application can ignore the underlying data communication protocol. l Data can be transmitted and received in a format that is convenient for applications. l ODBC is designed with emerging international ISO Call-Level Interface standard. l The ODBC database driver currently available for 55 most popular databases. OLE is used to design a reusable component software OLE is an object-oriented technology that can develop reusable software components using this technique. OLE Component Object Model Example Replica represents the fundamental transformation of application writing methods. The OLE architecture allows the application to use a shared object that provides a specific function, replacing the traditional programming program that each component is used for implementing the desired function. For OLE applications, text documents, charts, spreadsheets, emails, graphics, and sound editing, etc. are appeared as objects. Currently, Windows and Macintosh platforms support OLE objects, and the OLE object is the foundation of the future Windows operating system. ODBC and OLE work as part of the submitting OLE, Microsoft defines a set of data objects, which are called "OLE DB", which makes the OLE-oriented application to share and operate the data set as an object. This technology includes an ODBC provider that displays OLE DB objects via any ODBC driver. With this approach, any OLE DB application can access the displayed SQL data through the ODBC driver, and the ODBC driver will enable the ODBC driver to access a new type of client. For more information on OLE DB, please visit http://www.microsoft.com/data/.
