Page 259 - Open Soource Technologies 304.indd

Unit 11: Data Base Access

• If you chose adCmdTable or adCmdStoredProc, fill in the appropriate table or stored
procedure name in the Table or Stored Procedure Name drop-down list (see Figure 11.9).

Figure 11.9: A Table or Stored Procedure Name for the RecordSource Property.

13. Click OK to end the RecordSource dialog box.

11.5 ADO and ADOCE

ADO is Microsoft’s strategic, high-level interface to all kinds of data. An application that uses
ADO can access and manipulate data in a database server through an OLE database provider. The
primary benefits of ADO are ease of use, high speed, low memory overhead, and a small disk
footprint. ADO provides consistent, high-performance access to data for creating a front-end
database client or middle-tier business object using an application, tool, language, or even an
Internet browser.
ADO is the central component of the Microsoft Universal Data Access strategy. Universal Data
Access provides high-performance access to a variety of information sources, including relational
and non relational, and an easy-to-use programming interface that is tool- and language-
independent. These technologies enable corporations to integrate diverse data sources, create
easy-to-maintain solutions, and use their choice of the best tools, applications, and platform
services.
ADOCE provides a subset of ADO for the Windows CE operating system that includes
implementation of the Recordset and Field objects. ADOCE adds new database functionality to
Windows CE by enabling access to databases stored locally on a device and provides
synchronization of data to a network database. ADOCE provides access to the Windows CE
database engine from any COM-capable environment, such as the Microsoft Windows CE Toolkit
®
for Microsoft Visual Basic version 6.0.

LOVELY PROFESSIONAL UNIVERSITY 253