Creation of ODBC Connection to Microsoft SQL Server in Windows

                 

Introduction:

ODBC is an Open Database Connectivity. An ODBC driver uses the ODBC interface by Microsoft that allows applications to access data in DBMS using SQL as a standard for accessing the data.

An ODBC permits maximum interoperability, which means a single application can access different DBMS. Application end users can then add ODBC database drivers to link the application to their choice of DBMS.

Step:1

• Click on Start menu
• Select Control Panel
• Go to Administrative Tools and click on ODBC data source(32-bit)
•  In below figure, we have to create new User Data Source
• Click on ADD button

Step:2

• Select SQL Server
• Click on Finish button

Step:3

•  Here we create an ODBC data source that can be used to connect to SQL Server
•  Click on Next

Step:4

•  Here we have to provide login id and password of SQL Server
•  Click on Next button

Step:5

•     Again click on Next button

Step:6

•   Click on Finish button

Step:7

•  Here a new ODBC data source will be created and click on Test Data Source

Step:8

• We get the test completed successfully and click ok
• Click the OK button twice to return to the System DSN tab
• Click OK to exit the ODBC Data Source Administrator window

Thank you!

Mahendra Reddy,
Consultant Trainee (Analytics),
Mouritech Pvt Ltd,
Visakhapatnam.