| Application bitness | Which ODBC Administrator to use | Path to launch | |---------------------|--------------------------------|----------------| | 64-bit application (e.g., 64-bit Excel, SSMS, Power BI) | 64-bit version | C:\Windows\System32\odbcad32.exe | | 32-bit application (e.g., 32-bit Crystal Reports, MS Access, older software) | 32-bit version | C:\Windows\SysWOW64\odbcad32.exe |
This covers the critical 32-bit vs. 64-bit ODBC Administrator distinction, which is the most common point of failure. setup odbc connection windows 7 64 bit