using: c:windowssysWOW64odbcad32.exe

Feb 12, 2013  I'm trying to install the MS Access ODBC driver on my Win 7 pro laptop. I downloaded MDAC 2.8 and tried to install it, but can't seem to be able to do so. Nov 07, 2016  To open the ODBC Data Source Administrator in Windows 10. On the Start page, type ODBC Data Sources. The ODBC Data Sources Desktop App should appear as a choice. To open the ODBC Data Source Administrator in Windows 7. On the Start menu, click Control Panel. In Control Panel, click Administrative Tools. In Administrative Tools, click Data.

The PC is running Windows 7 64bit

I am trying to use ODBC Driver to connect data to SQL Server (back-end data) for MS Access (front-end GUI), using the ODBC wizard but it keeps failing. I just had the Window 7 installed.

1 Answer

That installs the drivers for OLEDB and ODBC. It needs to just set up the NEW connection string to the path of the .mdb file.

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

Update Odbc Drivers Windows 7

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?

3 Answers

Run the Datasource editor from this path c:WindowsSysWOW64odbcad32.exe.

Microsoft Access Odbc Driver Windows 7

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:WindowsSysWOW64odbcad32.exe.

Otherwise, you will get the 64-bit version, even if you enter odbcad32.exe in the search box.

Missing Odbc Drivers Windows 7

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%WindowsSysWoW64 folder.
• The 64-bit version of theOdbcad32.exe file is located in the %systemdrive%WindowsSystem32folder.

The Odbcad32.exe file displays the following types of data source names (DSNs):

• System DSNs
• User DSNs

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 windows-764-bit32-bitodbc or ask your own question.