Defines the protocol or method in which an application connects to a data store or data base.
- Active Data Objects (ADO)
ActiveX Data Objects) A programming interface from Microsoft that is designed as “the” Microsoft standard for data access. First used with Internet Information Server, ADO is a set of COM objects that provides an interface to OLE DB. The three primary objects are Connection, Command and Recordset.
- Active Data Objects .Net (ADO.Net)
ADO.NET is the data-access component of the Microsoft’s .NET Framework. It provides an extensive set of classes that facilitate efficient access to data from a large variety of sources, enable sophisticated manipulation and sorting of data.
- Data Access Objects (DAO)
DAO is the Microsoft library for accessing Microsoft Jet engine data sources such as Microsoft Office-based applications. DAO is replaced by ADO and ADO.Net.
- DB2 Connector
An IBM connectivity API to access DB2 sources.
- Java Database Connectivity (JDBC)
JDBC provides access to virtually any tabular data source from the Java programming language. It provides cross-DBMS connectivity to a wide range of SQL databases, and other tabular data sources, such as spreadsheets or flat files.
- Object Linking and Embedding/Database (OLE/DB)
A Microsoft low-level API designed to provide connections to different data sources. OLE/DB allowed connectivity to ODBC-based SQL providers/sources as well as other formats such as text and comma-delimited.
- Open Database Connectivity (ODBC)
A database programming interface from Microsoft that provides a common language for Windows applications to access databases on a network. ODBC is made up of the function calls programmers write into their applications and the ODBC drivers themselves.
