To connect to a Microsoft Jet 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. |
Filled |
Description |
Enter a brief description about the data source. |
Blank |
Provider |
Enter Microsoft.Jet.OLEDB.4.0. |
Blank |
Database File |
Enter the path and filename of the database. |
Blank |
System Database |
If you want to secure access to the specified database file, enter the path and filename of the database that contains database security information. |
Blank |
Click Create to save the configuration.