Overview of Internet Information Services 5.0 |
The Microsoft® Database Access component uses Microsoft® ActiveX® Data Objects (ADO) to access information stored in a database or other tabular data structure. Datadriven client/server applications deployed over the Web or an intranet can use this component to integrate information from a variety of sources, including both relational (SQL) and non-relational database management systems (DBMSs). The Database Access component consists of the following, all of which are released, documented, and supported together:
ADO can help you write applications that let you access and manipulate data in a database server through an OLE DB provider. The primary benefits of ADO are ease of use, high speed, low-memory overhead, and a small disk footprint. ADO supports key features for building client/server and Web applications.
ADO also features RDS, a high-performance client-side data caching technology that brings database connectivity to Web applications. You can use RDS to build intelligent Web applications that let you access and update data from any OLE DB provider, including ODBC-compliant DBMSs. Because you can implement RDS with familiar technology—off-the-shelf visual controls, HTML, and Microsoft® Visual Basic® Scripting Edition (VBScript)—RDS integrates seamlessly with existing Microsoft® Visual Basic® applications, so that you can transport them to the Web.
The Database Access component also includes ODBC and the OLE DB provider for ODBC. Used in conjunction with an appropriate ODBC driver, these components provide access to several popular DBMSs, including Microsoft® SQL Server™, Oracle databases, Microsoft® Access, and several other desktop databases.