Lately I installed a 32bit application on Windows x64.
Well, this application need SQL Server, so I configured DSN ODBC.
I had some problems with ODBC, since Windows x64 has 2 different ODBC panels … which I didnt’ know.
I found usefull info here 64 Bit Installation Concerns.
This is the part that solved my problem, and cleared my minds.
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 kind of application has is own registry.To setup DSN for 32-bit application you must use:
and for 64-bit application you must use:
There is not 32-bit edition of Windows XP on the XP Pro x64 media.
A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):
• The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%WindowsSysWoW64 folder.
• The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%WindowsSystem32 folder.
The Odbcad32.exe file displays the following types of data source names (DSNs):
• System DSNs
• User DSNs
source: 64 Bit Installation Concerns
more info here: The 32-bit version of the ODBC Administrator tool…
Technorati tags: Windows x64, 32bit