The Open Database Connectivity, shortly called as ODBC is a standard API (Application Programming Interface) for accessing the DBMS (Database management Systems). In this article we will show you the step by step approach to Create ODBC Connection for SQL Server in Window 10.
How to Create ODBC Connection for SQL Server
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 64-bit so, we are selecting the Set up ODBC data sources (64-bit)
TIP: If your system is 32-bit then select the 32-bit and follow the remaining steps.
Step 2: Once you click on the Set up ODBC data sources (64-bit) option, ODBC Data Source Administrator (64-bit) Window will be opened. From the below screenshot you an observe that, it is showing up the existing connections. To add new ODBC connection, please click on the Add button.
Step 3: Once you click on the Add button, Create New data Source window will be opened. Here we have to select the required driver from the list of available drivers. In this example, we want to create a ODBC connection for SQL Server so we are selecting the ODBC Driver 11 for SQL Server (any DBMS that support ODBC Connection). You can also select the SQL Server Native Client 11.0 (Only for SQL Server) as shown below
Step 4: Once you click on the Finish button, a new pop up window called Create a New data Source to SQL Server will be opened. Here we have to fill the require details:
- Name: Please specify unique name for this ODBC Connection. Here we ar assigning the name as SQL Server.
- Description: Please specify the valid description about the connection we are going to establish.
- Server: Please specify the Database Server name.
Step 5: Next, We have to provide the required credentials to connect with respective database (SQL Server). Let me provide the Username and password for our Microsoft SQL Server 2014. After you fill the details, please click on the Next button. This will connect the database and display the list of databases available for the user tutorialgateway.
TIP: Please replace those credentials with your own credentials.
Step 6: From the below screenshot you can observe that, we are selecting the AdventureWorksDW2014 database as our default database.
Step 7: Click on the finish button to finish configuring the ODBC connection for SQL Server in windows.
Step 8: Once you click on the finish button, a pop up window will be opened to test the connection. Either you can test it by clicking Test Data Sources.. button or else click on the cancel button. We strongly recommend you to test the data source
Step 9: Once you click on the Test Data Sources.. button, it will display the test result.
Following screenshot will show you the newly created ODBC connection SQL Server. Click OK to close the window.
Thank You for Visiting Our Blog