If you run ColdFusion on a Windows NT platform, you can access dBASE databases using ODBC drivers. 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 Directory |
Click Browse Server to locate and enter the path and filename of the dBASE database that you want to use as a data source. |
Blank |
Database Version |
From the drop-down list box, select the version number of the dBASE database. ColdFusion supports dBASE versions III, IV and 5.0. |
dBASE III |
Driver Settings/Collating Sequence |
From the drop-down list, select the order in which records display when you issue a Select statement with an Order By clause.
ASCII: This order sorts items alphabetically with uppercase letters preceding lowercase letters, as in "A, a, C, b."
International: This sort order is always alphabetic and disregards case, as in "A, b, C." |
ASCII |
Driver Settings/Page Timeout |
Enter the period of time, in tenths of a second, that a used page remains in the buffer before it is removed. |
600 |
Click Create to save the configuration.