Using OLE DB Connectivity  
 
 

The OLE DB driver is included with the Professional and Enterprise versions of ColdFusion on Win32 platforms.

 
 
  OLE DB data stores  
 

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.

 
 
  OLE DB providers for SQL data stores  
 

Performance gains can be made by running an OLE DB provider, instead of an ODBC driver, to process SQL. This is dependent on how the provider implement the data call. Some providers route OLE DB calls through the ODBC Driver Manager, while others go directly to the database. These latter are akin to native drivers in providing an alternative to ODBC. Providers are available for all the major relational DBMS products as well as the data stores listed above.

OLE DB is a Microsoft specification. For more information, including a list of provider vendors, go to their OLE DB site.



 
 
BackUp LevelNext
 
 

allaire     AllaireDoc@allaire.com
    Copyright © 1998, Allaire Corporation. All rights reserved.