How To Install Odbc |verified| Official

Installing ODBC correctly means you stop fighting connections and start analyzing data. And that’s the real win.

| If you need to connect to... | You need this driver... | |----------------|--------------------------| | | ODBC Driver 17/18 for SQL Server (Microsoft) | | PostgreSQL | psqlODBC | | MySQL | MySQL Connector/ODBC | | Oracle | Oracle ODBC Driver (painful, but works) | | Snowflake/BigQuery | Vendor-specific ODBC drivers (usually decent) | | Excel/Access | Built into Windows (Microsoft Access Driver) | how to install odbc

# Install unixODBC via Homebrew brew install unixodbc brew install msodbcsql18 Configure it manually (the fun part) nano /usr/local/etc/odbcinst.ini | You need this driver

Go open odbcad32.exe right now. Look at your System DSNs. If that list is empty, you have work to do. If that list is empty, you have work to do

You’re here because Tableau won’t connect to your legacy ERP system. Or because Python keeps throwing a Data source name not found error. Or because your boss sent you a CSV file that lives inside a SQL Server database, and now you have to build a bridge.