MS SQL Server Interview Question:

How To Define the Name and Server for a new DSN?

Submitted by: Administrator

Continuing from the previous tutorial, on the first screen of the "Create a New Data Source to SQL Server" wizard, you should enter 3 fields: Name, Description, and Server as suggested below:

Name: ggl_SQL_SERVER
Description: GlobalGuideLine.com SQL Server
Server: LOCALHOST

See the picture below:
ODBC DSN setting for SQL Server

Note that the name and description can be decided by yourself. But the server must be the network machine name where the SQL Server is running. In this example, LOCALHOST is the machine name for your local system.

Click Next and continue with the next tutorial to finish up creating a new DSN.
Submitted by: Administrator