Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Connecting Windows Applications to SQL Servers via ODBC
(Continued from previous topic...)
How Can Windows Applications Connect to SQL Servers via ODBC?
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:
- What Is Open Database Communication (ODBC)?
- How To Add a New DSN with the ODBC Driver for SQL Server?
- How To Define the Name and Server for a new DSN?
- How To Provide Login Information for a New ODBC DSN?
- Why Are You Getting Errors When Creating a New ODBC DSN?
- What Are the Requirements on SQL Server Network Connections?
- How To Start SQL Server Browser Service?
- How To Enable TCP/IP Protocol on a SQL Server?
- How To Verify the Port Number of the SQL Server?
- How To Configure ODBC DSN with Different Port Numbers?
- How To Configure and Test ODBC DSN Settings?
- How To Connect MS Access to SQL Servers through ODBC?
- How Can Windows Applications Connect to SQL Servers via ODBC?