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