Connecting to dBASE/FoxPro Databases
21
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”
on page 37.
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” on page 4.
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.
Summary of Contents for COLDFUSION 5-ADVANCED ADMINISTRATION
Page 1: ...Macromedia Incorporated Advanced ColdFusion Administration ColdFusion 5...
Page 20: ......
Page 56: ...38 Chapter 1 Advanced Data Source Management...
Page 74: ...56 Chapter 2 Administrator Tools...
Page 76: ......
Page 86: ...68 Chapter 3 ColdFusion Security...
Page 87: ...To Learn More About Security 69...
Page 88: ...70 Chapter 3 ColdFusion Security...
Page 130: ...112 Chapter 5 Configuring Advanced Security...
Page 132: ......
Page 154: ...136 Chapter 6 Configuring Verity K2 Server...
Page 162: ...144 Chapter 7 Indexing XML Documents...
Page 202: ...184 Chapter 8 Verity Spider...
Page 236: ...218 Chapter 10 Verity Troubleshooting Utilities...
Page 238: ......
Page 348: ...330 Chapter 14 ClusterCATS Utilities...
Page 349: ...Using sniff 331...
Page 350: ...332 Chapter 14 ClusterCATS Utilities...
Page 362: ...344 Chapter 15 Optimizing ClusterCATS...
Page 372: ...354 Index...