Creating ODBC Connections on Windows
When connecting to your SQL Server database with the admin tool you will need to connect via a DSN. If you are not familiar with how to create a DSN then follow the instructions in this lesson.
Launch the Administrative Tools Application
From the Control Panel, launch Administrative Tools.
Important Note: If you are running a 64-bit version of Windows you need to open the 32-bit version of the ODBC Administrator which you can find here:
c:\windows\sysWOW64\odbcad32.exe
For more information you may refer to this article on the Microsoft website:
http://msdn.microsoft.com/en-us/library/ms712362(VS.85).aspx
Open Data Sources (ODBC)
Install a System DSN
Select SQL Server Native Client Driver
If you are using SQL Server 2008 or later than select the SQL Server Native Client 10.0 driver. If you are using SQL Server 2005 then use the SQL Server driver. Click Finish.
If SQL Server Native Client 10.0 does not appear in your list then you need to download and install it from the Microsoft website. DO NOT USE the SQL Server ODBC driver. To download the driver visit:
http://www.microsoft.com/en-us/download/details.aspx?id=16978#SNAC
Download and run the Microsoft SQL Server 2008 Native Client installer to install the SQL Server Native Client 10.0 ODBC driver. After running the installer start over with this lesson.
Configure DSN Properties
Enter Login Information
On this screen enter the username and password for the user you created in the previous lesson (1).
Click Next (2).
I fail in testing Data Source, can you please help me?