ODBC
Open database connectivity (ODBC) is an API that provides a product-neutral interface between front-end applications and database servers. ODBC drivers are primarily used to connect Windows-based applications to various RDBMSs. However, ODBC drivers are available for almost all platforms, including UNIX, Mac, and others.
Installation
PostgreSQL can be compiled (or installed from packages) with the necessary drivers for ODBC access. Although PostgreSQL includes some built-in ODBC drivers, other projects are more supported. One of the more popular ODBC access methods is currently the unixODBC project (see www.unixodbc.org).
Installation of the ODBC drivers can be broken up into five steps:
Install and configure an ODBC manager.
Compile the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access