What is an ODBC Driver?

An ODBC driver uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data.


An ODBC driver uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data. ODBC permits maximum interoperability, which means a single application can access different DBMS. Application end users can then add ODBC database drivers to link the application to their choice of DBMS. For example: an Oracle ODBC driver for Oracle, or a SQL Server ODBC driver for SQL Server. 

The ODBC driver interface defines:

  • A library of ODBC function calls of two types:
    • Core functions that are based on the X/Open and SQL Access Group
    • Call Level Interface specification
    • Extended functions that support additional functionality, including scrollable cursors
  • SQL syntax based on the X/Open and SQL Access Group SQL CAE specification (1992)
  • A standard set of error codes
  • A standard way to connect and logon to a DBMS
  • A standard representation for data types

The ODBC solution for accessing data led to ODBC database drivers, which are dynamic-link libraries on Windows and shared objects on Linux/UNIX. These drivers allow an application to gain access to one or more data sources. ODBC provides a standard interface to allow application developers and vendors of database drivers to exchange data between applications and data sources.


Related:
DataDirect ODBC
DCI-FAQ -Hero-BG

DataDirect ODBC Connectors

Connect to your application with enterprise level ODBC connectivity