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.
However, because it is DBMS-independent, it can be used to build such cross-database tools. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. 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. Download Buy Now. The ODBC standard remains the most popular data access standard because it is a cross-platform standard and is widely supported by proprietary and open-source database systems.
An ODBC driver acts as an interface between an application and a data source, which can be anything like a file, a relational or non-relational database, or a cloud application. A separate driver is required for each data source to be accessed. Subscribe for monthly digest to get special offers.
Incorrect email address.
0コメント