The most common source of dynamic content for Web pages is information stored in a database. Chili!Soft ASP includes its own implementation of ADO that provides a powerful, standard interface to popular database management systems. Scripts that use ActiveX Data Objects (ADO) can extract, format, display, add, delete, and update information stored in external databases.

ADO relies on an Open Database Connectivity (ODBC) driver to connect to any given database. Using ADO, Chili!Soft ASP can connect to any ODBC compliant database, either locally or remotely, and across operating systems.

ADO consists of three objects: Connection, Command, and Recordset. The Connection object establishes a connection with the database. The Command object executes a database query or stored procedure. The Recordset object holds the results of a query for use by the ASP script.

Click Show Me for a live database example using ADO, or click next to continue the tour.