http://wiki.newhavensoftware.com/index.php?action=history&feed=atom&title=64-bit_vs._32-bit_ODBC_Drivers64-bit vs. 32-bit ODBC Drivers - Revision history2026-05-15T12:17:28ZRevision history for this page on the wikiMediaWiki 1.43.0http://wiki.newhavensoftware.com/index.php?title=64-bit_vs._32-bit_ODBC_Drivers&diff=1384&oldid=prevLuke steinmetzer: Created page with '==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 connec…'2012-04-06T20:49:22Z<p>Created page with '==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 connec…'</p>
<p><b>New page</b></p><div>==64-bit vs. 32-bit ODBC Drivers==<br />
<br />
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.<br />
<br />
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.<br />
<br />
==64-bit vs. 32-bit ODBC Data Source Admnistrators==<br />
<br />
To setup DSN for 32-bit application you must use:<br />
%WINDIR%\SysWOW64\odbcad32.exe<br />
<br />
and for 64-bit application you must use:<br />
%WINDIR%\System32\odbcad32.exe<br />
<br />
'''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.'''</div>Luke steinmetzer