ODBC is a database access protocol based on the Windows NT platform.
IBM, Microsoft, and others developed this most widely supported database protocol. It uses the SQL database access language.
To connect a Web site to a relational database using ODBC, you need:
- An ODBC driver
- A client software that can communicate with the driver, such as a Perl module
The process to connect the Web site to the database is as follows:
- Configure the driver on the Web server.
- Write the database query.
- The query returns the results.
SQL is a standardized database language that lets you access data in relational database management systems by describing the data you want to see.
It also lets you define the data in a database as well as manipulate and update that data.
An SQL statement consists of a command followed by one or more qualifying clauses, such as a table name or column name.
You can see examples of SQL commands and their functions in the following image.