Setting Up Your Database Connection Using ADO

FrontPage 2000 includes a new interface to configure your database - a new database option in the Web Settings dialog box that allows you to set up a wide variety of data sources instantly.

ADO and FrontPage 2000

FrontPage 2000 now manages database connections through ADO (Microsoft_® ActiveX_® Data Objects). There is no need to manage connections through the ODBC control panel, it is all done through FrontPage 2000. The implementation of a Global.asa file allows access to the database by setting up the server object and accessing the data source all with in the web, using ASP. FrontPage 2000 is not reliant on system DSNs.

ADO is designed as an easy-to-use application level interface to Microsoft's newest and most powerful data access paradigm, OLE DB. OLE DB provides high-performance access to any data source, including relational and non-relational databases, e-mail and file systems, text and graphics, custom business objects, and more. ADO is implemented with a small footprint, minimal network traffic in key Internet scenarios, and a minimal number of layers between the front-end and data source-all to provide a lightweight, high-performance interface. ADO is easy to use because it is called using a familiar metaphor-the OLE Automation interface, available from just about any tool and language on the market today. And since ADO was designed to combine the best features of and eventually replace RDO and DAO, it uses similar conventions with simplified semantics to make it easy to learn for today's developers.

What are the ActiveX Data Objects (ADO)?

ActiveX Data Objects are a language-neutral object model, that exposes data raised by an underlying OLE DB provider. The most commonly used OLE DB provider is the OLE DB provider for ODBC drivers, which exposes ODBC data sources to ADO. FrontPage 2000 uses these data objects to access local and remote data sources.

The ADO objects provide you with the fastest, easiest, and most productive means for accessing all kinds of data sources. The ADO model strives to expose everything that the underlying data provider can do, while still adding value by giving you shortcuts for common operations.

Next Page

Top