Answers

Question and Answer:

  Home  MS SQL Server

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

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.

 151 views

More Questions for you: