Launch Microsoft ODBC Data Administrator
On a 64-bit Microsoft OS, there will be two versions of Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe) in two different locations:
The Odbcad32.exe file displays the following types of data source names (DSNs):
- System DSNs (Visible to all users on the machine, including NT services)
- User DSNs (Only visible to current user and can only be used on the current machine)
In this tutorial, we’re going to create a System DSN to a SQL Server Database.
Click on Add button and select the latest SQL Server Native Client if possible, click Finish. You can download the latest SQL Server Native Client (sqlncli.msi) from Microsoft® SQL Server® 2012 Feature Pack link.
Click Next two times and Finish and you should see the entry on the System DSN tab.