Open and use ODBC Data Source Administrator

Applies to: SQL Server

This article 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, select Control Panel.

  2. In Control Panel, select Administrative Tools.

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

To open the ODBC Data Source Administrator in Windows Server

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

Check the ODBC SQL Server Driver Version (Windows)

Your computer might contain a variety of ODBC drivers, from Microsoft and from other companies. The following describes how to use the Windows ODBC Data Source Administrator to check the version of the installed ODBC drivers.

To check the ODBC SQL Server driver version

  • In the ODBC Data Source Administrator, select the Drivers tab.

    Information for the Microsoft SQL Server entry is displayed in the Version column.