- 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
HTTP URLs
With Internet Information Server 5.0 (IIS) being part of the Windows 2000 operating system, we are also allowed to use HTTP URLs to reference Exchange items using the following form:
http://<server-name>/<virtual-directory>/<virtual-path>
where
-
server-name refers to the local Exchange 2000 server name. In our example the machine name is "GOMEZAWIN2000." We can also use "localhost" for the server name. Remember that the Exchange OLE DB provider was designed only for accessing items on the local Exchange server.
-
virtual-directory is the Exchange HTTP virtual server virtual directory mapped to the public folder or private mailbox store. If you go into the Internet Services Manager MMC in the Administrative Tools program group in Windows 2000, you can see all of the virtual directories for your Exchange server. The name of the virtual directory does not have to coincide with the name of the public folder on the Exchange server. Basically, as long as the virtual directory is mapped to a valid public folder here, your user can type in "http://localhost/Raspberries" in a Web browser to get to a public folder on the Exchange server under Public Folders/Iced Tea Flavors/My Favorites/. See Chapter 5 for more on how IIS works with Outlook Web Access. We also have two default virtual directories that Exchange uses:
exchange. All private mailboxes in any store are available through this virtual directory.
public. This virtual directory is mapped to the top public folder in the default public folder tree. The default public folder name is "Public Folders."
- virtual-path is the rest of the path to the item. Let's look at some examples. Table 7.3 shows how to access the standard default mailbox folders using HTTP URLs.
Table 7.3 Default Mailbox Folder HTTP URLs
Folder | URL |
---|---|
Calendar | http://<server-name>/exchange/<user-alias>/Calendar |
Contacts | http://<server-name>/exchange/<user-alias>/Contacts |
Drafts | http://<server-name>/exchange/<user-alias>/Drafts |
Inbox | http://<server-name>/exchange/<user-alias>/Inbox |
Journal | http://<server-name>/exchange/<user-alias>/Journal |
Notes | http://<server-name>/exchange/<user-alias>/Notes |
Outbox | http://<server-name>/exchange/<user-alias>/Outbox |
Sent Items | http://<server-name>/exchange/<user-alias>/Sent%20Items |
Tasks | http://<server-name>/exchange/<user-alias>/Tasks |
Similarly, if we wanted to access a brand-new TLH called The Web Storage System that we had created on our local Exchange 2000 server, we could use the following URL:
http://localhost/The%20Web%20Storage%20System
If we had created a new public folder called Exchange Book Talk under the default Exchange public store, we could use the URL
http://localhost/public/Exchange%20Book%20Talk