ODBC

Updated: 12/29/2023 by Computer Hope

Short for Open Database Connectivity, ODBC was created by SQL (Structured Query Language) Access Group and released in 1992. ODBC is a widely accepted API (application programming interface) used to link or import data between different database applications. It is commonly used in various programs developed by Microsoft, such as Microsoft SQL, Microsoft Access, and Microsoft Excel.

ODBC Data Sources

ODBC Data Sources is a 32-bit and 64-bit program available through Windows Accessories used to adjust ODBC settings, DSN (Data Source Name), or tracing to find problems with ODBC connections.

ODBC Data Source

Within the ODBC Data Source window are the following tabs: User DSN, System DSN, File DSN, Drivers, Tracing, Connection Pooling, and About.

Getting ODBC Drivers

ODBC drivers are needed to connect to data sources. Some come installed with Windows. Others can be downloaded from their associated products. Below are links to commonly used ODBC drivers.

Connecting to ODBC Data Sources

To connect to an ODBC Data Source, the application must support the feature. Consult the application's documentation for directions. Below shows where to connect to an ODBC data source within Microsoft Access in Microsoft 365.

Connect to ODBC Data Source in Microsoft Access

Tip

See our DSN page for further information about DSN.

Computer acronyms, Database terms, DSN, Programming terms, Windows Accessories