Connect to SQLOLEDB database

To connect to an SQLOLEDB database:

  1. Complete the connection as described in the following table. For the steps involved in configuring your data source, see Configure OLE DB data sources.

 

Field

Description

Default

Data Source Name

This field displays the name that you entered on the OLE DB Data Sources page. You can edit it here.

 

Note: ColdFusion reserves The words “Registry” and “Cookie” for use. Do not use one of these words as a data source name.

Prefilled

Description

Enter a brief description about the data source.

Blank

Provider

Enter SQLOLEDB.

Blank

Server

Enter the name of the server that hosts the database. If the database is local, enclose the work local in parentheses: (local).

Blank

Default Database

Enter the name of the default database.

Blank

 

  1. Click Create to save the configuration.

Related topics