Currently i want to proof, which odbc data sources are configurated on a windows server 2008 R2 machine. When i open system32/odbcad32.exe
and SysWow64/odbcad32.exe
, they contains the same sources (64-Bit OS). How to check, which architecture which DSN use? For example in windows 10, this is displayed.
Thank you very much!
Best Answer
Correlated Registry Paths
HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/ODBC/ODBC.INI
HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI
The below Microsoft KB942976 may have the answer to your question.
I've never noticed this myself as the x86 and x64 ODBC System DSNs in my case are always in the applicable
system32/odbcad32.exe
for 32-bit andSysWow64/odbcad32.exe
for the 64-bit.If you are using only User DSN then this seems to be the Microsoft workaround on Server 2008 R2. You could change all to System DSNs I suppose.
For Windows 8 and Server 2012, there's the PowerShell Get-OdbcDsn but not applicable to Server 2008 R2.
Further Resources