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.
Comments
Post a Comment