View source

==64-bit vs. 32-bit ODBC Drivers==

It's important to understand which kind of DSN you have.  On an x64 system like the 64bit version of  Windows 7, you can create an ODBC connection(DSN) on the 32-bit side of the system or on the 64-bit side of the system.

CMS will create a system DNS on the 32-bit side of the system. 32-bit applications will only see ODBC  connections created in the 32-bit side, and 64-bits applications will only see ODBC connections from the 64-bit side. Each kind of application has is own registry.

==64-bit vs. 32-bit ODBC Data Source Admnistrators==

To setup DSN for 32-bit application you must use:
 %WINDIR%\SysWOW64\odbcad32.exe

and for 64-bit application you must use:
 %WINDIR%\System32\odbcad32.exe

'''Please note that the odbcad32.exe that is linked from the 64bit version of window's Control Panel is the 64-bit version and thus unable to see CMS's System DSN.'''