If you run ColdFusion on a Windows NT platform, you can configure a Microsoft Access database as a data source using ODBC and OLE DB drivers.
Notes
ODBC and OLE DB connections to Access are identical in the ColdFusion pages, but OLE DB connections are more robust than ODBC connections. Use OLE DB if possible.
Microsoft Access is a desktop database that is not designed for high-volume, multi-user use.
To complete the connection:
Select options as described in the following table. For the steps involved in configuring your data source, see Configure ODBC data sources.
Field |
Description |
Default |
Data Source Name |
This field displays the name that you entered on the main Data Sources page. You can edit it here. |
Filled |
Description |
Enter a brief description about the data source. |
Blank |
Database File |
Click Browse Server to locate and enter the path and filename of a database file. |
Blank |
System Database |
If you want to secure access to the specified database file, click Browse Server to locate and enter a database that contains database security information.
The system database is usually located in winnt/system32/system.mdw. |
Blank |
Driver Settings/ |
Enter the time (in tenths of a second) before a request for a ColdFusion page times out. |
600 |
Driver Settings/ |
Enter the total number of bytes that ColdFusion should use to cache application pages. Enter a value to optimize ColdFusion performance. |
0 |
Default Login/ Username |
If your ODBC data source requires a username and password to restrict access, enter the username. Remember that to verify any data source protected with a username and password, you have to enter the login information. |
admin |
Default Login/ Password |
If you have entered a username to restrict access, enter a password. |
None |
Click Create to save the configuration.
For tips about working with a Microsoft Access database, refer to the book Advanced ColdFusion Server Administration.