MACROMEDIA COLDFUSION 5-ADVANCED ADMINISTRATION, Manual

Page: 40 / 372

22 Chapter 1 Advanced Data Source Management
ODBC: MERANT dBASE/FoxPro Driver options (Windows)
The following table describes the ColdFusion ODBC options for MERANT dBASE/
FoxPro on Windows. 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: Clipper, dBASE versions III, IV, V, and FoxPro
versions 2.5, 3.0.
Data File Extension The file extension to use for data files. The default setting is
DBF. The setting cannot be more than three characters, and
it cannot be one the driver already uses, such as MDX or
CDX. The Data File Extension setting is used for all Create
Table statements.
•
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.”