If you run ColdFusion on a UNIX 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 ODBC 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 to the dBASE database that you want to use as a data source. |
Blank |
Database Version |
From the drop-down list, select the version type (dBASE or FoxPro) and version number of the database. |
dBASE V |
Data File Extension |
Enter the extension of the specified database file. |
DBF |
Use international collating sequence |
This option determines the order in which records display when you issue a Select statement with an Order By clause.
If you enable this option, the driver uses the international sort order as defined by your operating system. This order sorts alphabetically and disregards case, as in "A, b, C."
If you do not enable it, the driver uses the ASCII sort order. This order sorts items alphabetically with uppercase letters preceding lowercase letters, as in "A, a, C, b." |
Disabled |
Click Create to save the configuration.