Luckydigi

In Windows 7, the Data Sources (ODBC). Upon clicking Add. The excel drivers I need is not listed in the data sources management console in my windows 7. Microsoft ODBC Driver 11 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012, SQL Server 2014 and Windows Azure SQL Database.

1. How To Reinstall Odbc Driver In Windows 7 64 Bit
2. Excel Odbc Driver Windows 7

-->

APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

This topic describes how to open the ODBC Data Source Administrator. The ODBC Data Source Administrator is a Windows component. Use the ODBC Data Source Administrator to create and manage ODBC data sources.

To open the ODBC Data Source Administrator in Windows 10

1. 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

1. On the Start menu, click Control Panel.

2. In Control Panel, click Administrative Tools.

3. In Administrative Tools, click Data Sources (ODBC).

To open the ODBC Data Source Administrator in Windows Server 2008

1. On the Start menu, point to Administrative Tools, and then click Data Sources (ODBC).

Note

For connections to Azure Active Directory Authentication for SQL Database install the latest driver, such as ODBC Driver 13.1 for SQL Server.

How To Reinstall Odbc Driver In Windows 7 64 Bit

See Also

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 IrregularHighly Irregular

3 Answers

Run the Datasource editor from this path c:WindowsSysWOW64odbcad32.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

Zoredache

Excel Odbc Driver Windows 7

Zoredache

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.

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.