What is an ODBC Driver? An ODBC (Open Database Connectivity) driver is a software component that allows an application—such as Excel, Power BI, Tableau, or a custom script—to connect to a database using the ODBC interface. Think of it as a translator: the application speaks ODBC, and the driver translates that into the database’s native language (e.g., SQL Server, MySQL, PostgreSQL, Oracle).
odbcinst -j # Shows configuration files and installed drivers Once installed, you must often configure a DSN (Data Source Name) so applications can use the driver. odbc driver install
[PostgreSQL] Description = PostgreSQL ODBC driver Driver = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libpsqlodbcw.so Then define a DSN in /etc/odbc.ini : What is an ODBC Driver
# Install unixODBC (driver manager) brew install unixodbc brew install psqlodbc Example: SQL Server ODBC driver brew install msodbcsql18 odbcinst -j # Shows configuration files and installed
odbcinst -q -d # List installed drivers Using Homebrew (simplest):