When configuring an Application to use a DSN via the ODBC Administrator it is important to understand if you need a x64 ODBC connection or a x86 ODBC connection.
It’s important to understand which kind of DSN you have. On an x64 system, you can create an ODBC connection(DSN) on the 32-bit side of the system or on the 64-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 application has is own place in the registry.
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 (this is the one in the W7 control panel)
http://support.microsoft.com/kb/942976/en-us
No comments:
Post a Comment