Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - ODBC - What Is Open Database Communication
(Continued from previous topic...)
What Is Open Database Communication (ODBC)?
ODBC, Open Database Communication, a standard API (application program interface)
developed by Microsoft for Windows applications to communicate with database management servers.
If you want to access a database server through an ODBC driver from an application program,
you need to meet the following requirements:
- An ODBC driver specifically designed for the database server.
- An ODBC DSN (Data Source Name) - an ODBC configuration representing the ODBC driver
and database server.
- An ODBC API (Application Programming Interface) for your application program
to interact with database server through the ODBC driver.
For example, if you want to a SQL Server in a PHP script through an ODBC driver,
you need to make sure that:
- An ODBC driver for MS SQL Server - The ODBC driver is installed as part of the Windows system.
- An ODBC DSN - You need to create one yourself using the ODBC configuration tool.
- An ODBC API in PHP language - The API is installed as part of the PHP engine.
(Continued on next topic...)
- 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?