Search notes:

ODBC

ODBC is one of the primary MDAC technologies (the two others being ADO and OLE DB).

With ODBC, only relational databases can be accessed.

A follow-up API to ODBC was/is OLEDB.

OLE DB Provider for ODBC

The OLE DB provider for ODBC is MSDASQL. It is implemented in %CommonProgramFiles%\System\ole db\msdasql.dll.

The OLE DB provider for ODBC is primarly meant to be used as a workaround for OLE DB applications that need to access data sources for which no OLE DB provider, but an ODCB driver, exists.

If an OLE DB connection string is missing the provider key, the system defaults to this Microsoft OLE DB Provider for ODBC Drivers (or short: «MSDASQL»).

The CLSID of MSDASQL is {C8B522CB-5CF3-11CE-ADE5-00AA0044773D}.

See also

The registry key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC

The R packages odbc and RODBC.

The PowerShell command noun odbcDriver. The cmdLet get-odbcDriver returns a list of installed ODBC drivers.

The .NET namespace for the .NET Framework Data Provider for ODBC is found in the System.Data.Odbc namespace.

The ODBC driver for SQL Server seems to be sqlsrv32.dll

MSDASQL is Microsoft's OLE DB provider for ODBC.

%SystemRoot%\ODBCINST.INI

The workbookConnection object of Excel seems to be able to connect to ODBC sources.

The deprecated ODBC configuration program odbcconf.exe.

JDBC

Access allows to export a table into an ODBC database under the menu Access under the menu External Data -> Export.