- 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
Summary
We hope that this chapter provided you with several new tools to add to your Exchange 2000 development belt. We discussed the theories behind Universal Data Access, introduced the enhancements to ADO for dealing with Web Storage System data, learned two ways to build a URL for any item in the Web Storage System, and studied the syntax for WSS SQL. If your organization has invested in Microsoft Exchange as a messaging, scheduling, and collaboration platform, it has a wealth of data in the form of e-mail messages, contacts, appointments, tasks, conversation threads, documents, and so on. Leveraging your prior programming experiences with ADO and "conventional" SQL, you will soon be developing robust applications for Exchange 2000 using the familiar ADO object model and writing robust WSS SQL queries against that data with the elegance and ease of a database.