58

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?

|improve this question
  • On my version of Windows (10 pro), a shortcut to ODBC Data Sources (32-bit) is included in the Windows Administrative Tools folder (along with the 64-bit version, and things like Computer Management, Services, etc.) – mwfearnley Oct 11 at 8:37
90

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

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

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.

|improve this answer
  • This should be upvoted more! – Denys Vitali Jun 8 '16 at 9:23
  • @DenysVitali except, apparently, if you put the whole path in the search box, you still only get the 64-bit version. I ended up having to open a command window – Auspex Jun 28 '17 at 10:21
  • Seriously? Really strange... but I'm not surprised anymore when Windows is involved... – Denys Vitali Jun 28 '17 at 13:48
  • 1
    @Auspex for me it works entering the full path c:\Windows\SysWOW64\odbcad32.exe – Carlos Escalera Alonso Jul 17 '17 at 17:04
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
|improve this answer

protected by Community♦ Sep 2 '17 at 19:36

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.