Configure or Setup ODBC Connection

Today, I will be discussing about how to configure or setup odbc connection. ODBC connection is used for connecting with external database.

Below are the steps required for configuring ODBC connection with Sql server data base.

Step 1) Search odbc setup from start up menu.






















Step 2) Go to System DSN tab and click on add button.


















Step 3) Select a drive for which you want to setup data source. In my case i have selected SQL Server.















Step 4) Add information for new data source to sql server .

• Name
• Description
• Sql server - With whom you want to connect

Step 5) Add authentication ID details.


















Step 6) Select the default data base.

















Step 7) Click on next and finish button. You may test the connection by clicking on test data source.
























Result