62

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?

Highly Irregular
  • 3,121

3 Answers3

95

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

Ref: Link

Glorfindel
  • 4,158
Zoredache
  • 20,438
23

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.

Community
  • 1
Carlos Escalera Alonso
  • 395
5

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
Bulent
  • 51