BackUp LevelNext

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:

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.