CF developers can now access a range of new data stores, including:
- MAPI-based data stores such as Microsoft Exchange and Lotus Mail
- Non-relational data stores, such as Lotus Notes
- LDAP 2.0 data
- Data from OLE applications like word processors and spreadsheets
- Mainframe data
- HTML and text files, flat-file data
Enabling this capability requires installation of OLE DB providers available from third-party vendors. The provider software handles data processing in response to requests from the consumer, in this case ColdFusion.
After installing and configuring the provider software, you can open the CF Administrator Data Sources OLE DB page and add data stores supported by that provider. As with other CF data sources, you enter a name and description and select advanced settings as needed. You will also need to enter:
Provider -- the ProgID
ProviderDSN -- the data source name
The data source displays on the main OLE DB page and can be used in queries.
|