More recently, Microsoft introduced the ADO data access standard. ODBC has become the de-facto standard for standards-based data access in both relational and non-relational database management systems DBMS. The ODBC standard enables maximum interoperability thereby enabling application developers to write a single application to access data sources from different vendors. A data source is simply the source of the data. It can be a file, a particular database on a DBMS, or even a live data feed.
The data might be located on the same computer as the program, or on another computer somewhere on a network. Magnitude Blog. What is ODBC? Data Source A data source is simply the source of the data. Many misconceptions about ODBC exist in the computing world. To the application programmer, it is a library containing data access routines.
To many others, it is the answer to all database access problems ever imagined. ODBC 3. Applications call the functions in these drivers to access data in a DBMS-independent manner. A Driver Manager manages communication between applications and drivers. In fact, the vast majority of ODBC applications and drivers available today are written by companies other than Microsoft.
It is important to understand that ODBC is designed to expose database capabilities, not supplement them. Thus, application writers should not expect that using ODBC will suddenly transform a simple database into a fully featured relational database engine.
Nor are driver writers expected to implement functionality not found in the underlying database. An exception to this is that developers who write drivers that directly access file data such as data in an Xbase file are required to write a database engine that supports at least minimal SQL functionality. Applications that use ODBC are responsible for any cross-database functionality. For example, ODBC is not a heterogeneous join engine, nor is it a distributed transaction processor.
0コメント