| Version | Location | Purpose | |---------|----------|---------| | | C:\Windows\System32\odbcad32.exe | Manages 64-bit DSNs for 64-bit apps | | 32-bit | C:\Windows\SysWOW64\odbcad32.exe | Manages 32-bit DSNs for 32-bit apps | ⚠️ Common Mistake : The Start Menu shortcut opens the 64-bit version by default. If your application is 32-bit (like many older MS Office versions), you need the 32-bit administrator! How to Access Both ODBC Administrators Method 1 - Run Commands:
# 64-bit ODBC Administrator %windir%\system32\odbcad32.exe %windir%\syswow64\odbcad32.exe windows 7 x64 odbc
reg query "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers" windows 7 x64 odbc
reg query "HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers" windows 7 x64 odbc