MS SQL Server Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

How Can Windows Applications Connect to SQL Servers via ODBC?

MS SQL Server Interview Question
MS SQL Server Interview Question

Answer:

One way of connecting a windows application to a SQL Server is to use ODBC drivers. The requirements to do this is summarized here:

* The SQL Server must have TCP/IP protocol enabled with a specific port number.
* The SQL Server Browser Service must be running on the server machine.
* A ODBC DSN must be created to represent the connection to SQL Server on the specified port number.
* The local windows application must be able to support ODBC API calls.

The diagram below shows how MS Access can connect to a SQL Server through the ODBC driver:
SQL Server ODBC Connection

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
How To Connect MS Access to SQL Servers through ODBC?What Are the Requirements to Use ODBC Connections in PHP Scripts?