MS SQL Server Concepts and Programming Question: Download Questions PDF
How To Define the Name and Server for a new DSN?
Answer:
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.
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.
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Add a New DSN with the ODBC Driver for SQL Server? | How To Provide Login Information for a New ODBC DSN? |