How To Define the Name and Server for a new DSN?
Submitted by: AdministratorContinuing 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
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
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | What Are Binary String Data Types in MS SQL Server? |
☺ | How To Use Subqueries with the IN Operators in MS SQL Server? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
☺ | How To Configure and Test ODBC DSN Settings? |
☺ | What Are the Character String Functions Supported by SQL Server 2005? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |