Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 54 down vote accepted

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


share|improve this answer
Zoredache, still helpful years later! Thanks for posting the answer. – plditallo Jan 7 at 20:28

Just a note don't use the search box in the start menu to look for odbcad32.exe (the same as if you type odbc only). Even the name is the same it opens the one in C:\Windows\System32 not c:\Windows\SysWOW64\

Or if you want to open it from here just type the whole path in the search box to get the correct one c:\Windows\SysWOW64\odbcad32.exe

I know it because I did this mistake and I thought I was creating 32 bit DSN, but they didn't work until I found out this was the problem.

I know is confusing because is the same name file. But windows has its mysteries, or maybe there's a reasonable explanation.

Anyway just follow Zorodache answer, go to the mentioned folder and open it directly from there, and it will be fine.

share|improve this answer
This should be upvoted more! – Denys Vitali Jun 8 at 9:23

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
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .