OLE DB data sources are available only for Windows NT and Windows 2000 platforms. The OLE DB Data Source page displays existing OLE DB data sources by name and provider, and the connection status (OK or Failed). Use this page to configure a new data source, edit the configuration of an existing source, or verify connections. (Note that you can also manage connections using the Datasource Connection Summary page.)
Note: Before you can configure an OLE DB data source, you must have installed a recent version of the Microsoft Data Access Components (MDAC). MDAC includes two OLE DB providers—SQLOLEDB and MSDASQL. For Access databases, Microsoft makes available a Jet provider. For SQL Server, Microsoft offers MSDASQL and SQLOLEDB providers. If you use MSDASQL, you must have an OBDB data source already defined for the database. For more information, see the book Advanced ColdFusion Server Administration.
To configure an OLE DB data source:
Click Server>OLE DB data sources in the ColdFusion Administrator navigation frame. The OLE DB Data Source page appears.
Enter a name in the Data Source Name field. ColdFusion reserves the words "Registry" and "Cookie" for use. Do not use one of these words as a data source name.
Select a provider from the drop-down Provider list. If you are creating a data source using a provider other than SQLOLEDB or Jet, select Other from the list.
Click Add to see the Create OLE DB Interface Data Source page. The fields you see depend on the selected provider.
Complete the configuration as described in the appropriate topic for your provider: SQLOLEDB, Microsoft Jet, or Other OLE DB. To cancel the configuration any time, click Cancel.
You can set further specifications for the data source, such as requiring use of a username and password. Click CF Settings to see additional fields. Complete these fields as described in Select ColdFusion Settings.
Click Create
when you finish configuring the data source.
ColdFusion Administrator verifies automatically that it can connect
to the data source. If verification succeeds, the Data Source page displays
with the new data source highlighted. If the verification fails, an error
message displays. For information about troubleshooting verification failures,
see the book Advanced ColdFusion Server
Administration.
To edit an OLE DB data source:
On the OLE DB data sources page, click a name in the Data Source Name column. The Edit OLE DB Data Source page appears.
Edit the configuration as described in the appropriate topic for your selected provider: SQLOLEDB, Microsoft Jet, or Other OLE DB. To cancel your changes any time, click Cancel and your original configuration remains intact.
To set further specifications for the data source, click CF Settings to see additional fields. Complete the fields as described in Select ColdFusion Settings.
Click Update
when you finish changing a configuration.
ColdFusion Administrator verifies automatically that it can connect
to the data source. If verification succeeds, the Data Source page displays
with the new data source highlighted. If the verification fails, an error
message displays. For information about troubleshooting verification failures,
see the book Advanced ColdFusion Server
Administration.