- The ADO/OLE DB Conspiracy
- What Does ADO 2.5 Have to Do with Exchange 2000?
- The Role of the Web Storage System
- The Exchange OLE DB Provider
- File URLs
- HTTP URLs
- Programmatically Getting a User's HTTP Mailbox Folder URLs
- The Open Method of the ADO 2.5 Record Object
- Using Web Storage System SQL to Get a List of Folders
- Web Storage System SQL
- The SELECT Statement
- The ORDER BY Clause
- The RANK BY Clause
- Some Unsupported SQL
- Summary
What Does ADO 2.5 Have to Do with Exchange 2000?
Thus we arrive at ADO 2.5, the latest release of the ActiveX Data Objects library. Even if you were already familiar with the preceding whirlwind explanation of ADO and OLE DB, you might still be wondering how ADO works with Exchange data. Figure 7.2 shows the ADO 2.5 object model.
){kind=link}
Figure 7.2
The ADO 2.5 object model
You are probably accustomed to using ADO to access relational databases such as Microsoft SQL Server. You know all about Recordset objects and writing SQL queries against tables in a database. You can leverage all of that programming experience when using ADO 2.5 to manipulate what we call semistructured data, such as that produced by Exchange. In fact, most of the enhancements to ADO 2.5 have been implemented for the purpose of working with hierarchical data stores such as a file system or a mail store. Table 7.1 summarizes how the major objects in ADO 2.5 can be used with Exchange 2000.
Table 7.1 The Use of ADO 2.5 Objects in Exchange 2000
| ADO 2.5 Object | Exchange 2000 Use |
|---|---|
| Record | Opens or creates an item or folder using a URL. |
| Recordset | Returns a collection of items in a folder or folder hierarchy. Also allows you to navigate a folder hierarchy. |
| Fields | Accesses the properties of an Exchange item. |
| Connection | Opens a connection to a folder, although this is not always required. |
| Stream | Accesses resources as streaming bits of data (i.e., open attachments in e-mail). |