Microsoft’s SQL Server Native Client 11.0 driver is a single DLL (dynamic link library). That 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. Let me show you the step by step approach to Create SQL Server Native Client Connection in Windows 10.
How to Create SQL Server Native Client Connection
Step 1: Go to the search bar and type the Set up ODBC data sources, and this shows 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 opened. Please click on the Add button to add a new data source. Here, we are selecting the SQL Server Native Client 11.0 (Only for SQL Server )
TIP: Please 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 opened. Please fill the required details:
- Name: Please specify a unique name for this ODBC Connection. Here, we are assigning the name as SQLServer.
- Description: Please specify the accurate description of 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. It connects the database and displays the list of databases available for the user tutorial gateway.
TIP: Please replace those credentials with your credentials.
Step 5: From the screenshot below, 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.
Once you click on the finish button, a pop-up window 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 finish configuring.
From the screenshot below, you can observe that it is displaying Test completed Successfully as the test result.
The following screenshot shows the newly created SQL Server Native Client Connection for SQL Server. Click OK to close the window.