Connecting to dBASE/FoxPro Databases

On Windows and UNIX, ColdFusion lets you access dBASE/FoxPro databases using ODBC drivers.

Note

Because dBASE and FoxPro databases are configured identically in the ColdFusion Administrator, they are discussed together in this section. For information on connecting to Visual FoxPro databases, see "Connecting to Visual FoxPro Databases".

Configuring dBASE/FoxPro options (Windows)

If you install ColdFusion on a Windows server, you can configure a dBASE/FoxPro database as a ColdFusion data source using ODBC or OLE DB. For information about using OLE DB with ColdFusion data sources, see "About OLE DB".

ODBC: Microsoft dBASE/FoxPro Driver options (Windows)

The following table describes ColdFusion ODBC options for dBASE/FoxPro data sources. You set these options when you configure a ColdFusion data source.

Option

Description

Data Source Name
A name for your ODBC data source.

Description
Descriptive information about the data source.

Database Directory
The path dBASE database that you want to use as an ODBC data source.

Database Version
Enter the version number of the dBASE or FoxPro database that you want to use: dBASE versions III, IV, and 5.0 and FoxPro versions 2.0, 2.5, and 2.6.

Driver Settings
Collating Sequence Determines the sequence in which the fields sort.

Page Timeout Specifies the period of time, in tenths of a second, that an unused page remains in the buffer before being removed.

Option	Description
Data Source Name	A name for your ODBC data source.
Description	Descriptive information about the data source.
Database Directory	The path dBASE database that you want to use as an ODBC data source.
Database Version	Enter the version number of the dBASE or FoxPro database that you want to use: dBASE versions III, IV, and 5.0 and FoxPro versions 2.0, 2.5, and 2.6.
Driver Settings	Collating Sequence Determines the sequence in which the fields sort.
Page Timeout Specifies the period of time, in tenths of a second, that an unused page remains in the buffer before being removed.

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

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

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

Advanced ColdFusion Administration
Advanced Data Source Management