How to create DSN for Microsoft SQL Server
This article will help you to create a System Data Source Name (DSN) for Microsoft SQL Server on your local machine.
Open Control Panel window, you will see different icons as shown in Pic 1.
Doubble click on ODBC Data Source Administrator icon.
Now you will see ODBC Data Source Administrator window (as shown below).
Select System DSN tab, and click Add.
To Create a new DSN for an Microsoft SQL Server, Select SQL Server driver and click Finish.
In this example I am using DSN name as MyDSN.
Enter the name you like to use for DSN and then choose SQL Server to which you want to connect. If SQL Server is located on the same machine you can choose Local. If Server is not located on the same machine then you need to enter the IP Address or domain name to connect to that Server.
Enter the domain name or IP Address and Click Next.
Choose authenication method. Enter your Login ID and Password to connect to SQL Server and Click Next two time to skip next Screen, then Click Finish.
At last step you will have the option to test your Connection.
After a System DSN has been created you can use it within any ASP page located on the same computer.
Connecting to database with DSN Connection