Choosing CML Data Access Strategy

The Corporate Media Library (CML) application requires access to two very different information stores:

• The relational SQL Server™ CML database that contains tables with library data and stored procedures
• F & M Corporation's Microsoft® Exchange Server directory, the hierarchical data store that contains employee names, locations, phone numbers, and so forth

The CML developers chose ADO to access the SQL Server database objects from the COM components. RDS is used to access the database from client-side scripts; RDS in the CML Application describes how the CML uses RDS. ADSI is used to extract information from the Exchange Server directory; ADSI in the CML Application describes how the CML uses ADSI.