MS SQL Server Concepts and Programming Question:
How Can Windows Applications Connect to SQL Servers via ODBC?
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
* 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
| Previous Question | Next Question |
| How To Connect MS Access to SQL Servers through ODBC? | What Are the Requirements to Use ODBC Connections in PHP Scripts? |