How can I open the 32-bit ODBC Data Source Administrator in Windows 7 64-bit?
Run the Datasource editor from this path c:\Windows\SysWOW64\odbcad32.exe
.
Ref: http://blogs.msdn.com/b/farukcelik/archive/2008/10/17/why-my-32-bit-applications-cannot-see-the-odbc-dsns-that-i-created-on-my-64-bit-machine.aspx
Just a small note to Zorodache answer, if you use the search box from the start menu type the whole path to get the correct version c:\Windows\SysWOW64\odbcad32.exe
.
Otherwise, you will get the 64-bit version, even if you enter odbcad32.exe
in the search box.
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%\Windows\SysWoW64 folder.
- The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.
The Odbcad32.exe file displays the following types of data source names (DSNs):
- System DSNs
- User DSNs