The Microsoft’s SQL Server Native Client 11.0 driver is a single DLL (dynamic link library), which contains run time support for the application using APIs to connect with SQL Server 2005 to SQL Server 2014, and Windows Azure SQL Database. When you are working with SQL Server then this connection is faster than the ODBC Connection. In this article we will show you the step by step approach to Create SQL Server Native Client Connection in Window 10.
How to Create SQL Server Native Client Connection
Step 1: Go to search bar and type Set up ODBC data sources, and this will show two options: 32-bit & 64-bit. Our system is 32-bit so, we are selecting the Set up ODBC data sources (32-bit)
TIP: If your system is 64-bit then select the 64-bit and follow the remaining steps.
Step 2: Once you click on the Set up ODBC data sources (34-bit) option, ODBC Data Source Administrator (34-bit) Window will be opened. Please click on the Add button to add new data source. Here we are selecting the SQL Server Native Client 11.0 (Only for SQL Server ) as shown below.
TIP: Pleas refer Create ODBC Connection to understand the steps involved in creating ODBC connection in Windows
Step 3: Once you click on the Finish button, a new window called Create a New data Source to SQL Server will be opened. Pleas fill the require details:
- Name: Please specify unique name for your this ODBC Connection. Here we are assigning the name as SQLServer.
- Description: Please specify the valid description about the connection we are going to establish.
- Server: Please specify the SQL Database Server name.
Step 4: Next, We have to provide the required credentials to connect with the SQL Server. Let me provide the Username and password for my Microsoft SQL Server 2014. Once you fill the details, click on the Next button. This will connect the database and display the list of databases available for the user tutorial gateway.
TIP: Please replace those credentials with your own credentials.
Step 5: From the below screenshot you can observe that, we are selecting the Adventure Works DW 2014 database as our default database.
Step 6: Click on the finish button to finish configuring the SQL Server Native Client Connection in windows.
Step 7: Once you click on the finish button, a pop up window will be opened to test the established data connection. Either you can test it by clicking Test Data Sources.. button or else cancel it. It is always advisable to test the data source before, you finish configuring.
Step 8: From the below screenshot you can observe that, it is displaying Test completed Successfully as the the test result.
Following screenshot will show you the newly created SQL Server Native Client Connection for SQL Server. Click OK to close the window.
Thank You for Visiting Our Blog