64-bit vs. 32-bit ODBC Drivers

From NewHaven Software Wiki

Jump to: navigation, search

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.

Retrieved from "http://wiki.newhavensoftware.com/index.php/64-bit_vs._32-bit_ODBC_Drivers"
Personal tools