User Guide

Connecting to dBASE/FoxPro Databases 23
Configuring dBASE/FoxPro Driver options (UNIX)
If you install ColdFusion Server on a UNIX server, you can configure dBASE/FoxPro
as a ColdFusion data source using the MERANT ODBC driver. The following table
describes the ColdFusion ODBC options for dBASE/FoxPro (Solaris). You set these
options when you configure a ColdFusion data source.
Option Description
Data Source Name A name for your ODBC data source.
Description A short description of the data source.
Database Directory The name, including the complete path, of the database file
that you want to use as the ODBC data source.
Database Version The version number of the dBASE/FoxPro database that you
want to use. ColdFusion supports dBASE V, IV, and FoxPro
v3.0.
Driver Settings • Use lowercase file extension (.dbf) Specifies whether
lowercase file extensions are accepted. Select this option
to accept lowercase extensions. Clear this option to accept
only uppercase extensions.
• Use international collating sequence Determines the
order in which records display when you issue a Select
statement with an Order By clause.
If you do not select this option, the driver automatically
uses the ASCII sort order. This order sorts items
alphabetically with uppercase letters preceding lowercase
letters. For example, “A, b, C” sorts as “A, C, b.”
If you select this option, the driver uses the international
sort order as defined by your operating system. This sort
order is always alphabetic, regardless of case; the letters
from the previous example would sort using as “A, b, C.”