Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Connecting Windows Applications to SQL Servers via ODBC

By: FYIcenter.com

(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:
   

1. What Is Open Database Communication (ODBC)?
2. How To Add a New DSN with the ODBC Driver for SQL Server?
3. How To Define the Name and Server for a new DSN?
4. How To Provide Login Information for a New ODBC DSN?
5. Why Are You Getting Errors When Creating a New ODBC DSN?
6. What Are the Requirements on SQL Server Network Connections?
7. How To Start SQL Server Browser Service?
8. How To Enable TCP/IP Protocol on a SQL Server?
9. How To Verify the Port Number of the SQL Server?
10. How To Configure ODBC DSN with Different Port Numbers?
11. How To Configure and Test ODBC DSN Settings?
12. How To Connect MS Access to SQL Servers through ODBC?
13. How Can Windows Applications Connect to SQL Servers via ODBC?