Connect to Microsoft dBASE database

If you run ColdFusion on a Windows NT platform, you can access dBASE databases using ODBC drivers. To complete the connection:

  1. 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

 

  1. Click Create to save the configuration.

Related topics