How can I open the 32-bit ODBC Data Source Administrator in Windows 7 64-bit?

I want to add 32-bit data sources. There seems to be no obvious way to see existing instances of these or create new ones.

How can I open the 32-bit "ODBC Data Source Administrator" window in Windows 7 64-bit?

2

3 Answers

Run the Datasource editor from this path c:\Windows\SysWOW64\odbcad32.exe.

Ref:

2

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.

4

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