What is ODBC connectivity?

Answer 1

ODBC (Open Database Connectivity) provides a way for client programs (eg Visual Basic, Excel, Access, Q+E etc) to access a wide range of databases or data sources.

ODBC is a standardized API, developed according to the specifications of the SQL Access Group, that allows one to connect to SQL databases. It defines a set of function calls, error codes and data types that can be used to develop database independent applications.

ODBC is usually used when database independence or simultaneous access to different data sources is required.

Answer 2

Short for Open DataBase Connectivity, a standard database access method developed by the SQL Access group in 1992. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver , between an application and the DBMS. The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant -- that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them. Since version 2.0, the standard supports SAG SQL.

Answer 3

ODBC stands for Open DataBase Connectivity.

Typically when a person needs to access data from a database you need to use a specific language that the database understands, i.e., SQL.

ODBC is the translator of that SQL query to a language which is understood by the underlying database.

Answer 4

ODBC is an open data base connectivity protocol that allows you to use a language--like SQL--to query two different DB's. As an example this is one of the ways to interface Oracle and MS Access.

Hope this helps