To connect to an SQLOLEDB database:
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 |
Click Create to save the configuration.