Connecting to Visual FoxPro Databases
37
Connecting to Visual FoxPro Databases
On Windows, ColdFusion lets you access Microsoft Visual FoxPro databases using
ODBC or OLE DB. For information about using OLE DB with ColdFusion data
sources, see “About OLE DB” on page 4.
The following table describes ColdFusion ODBC options for Visual 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
A short description of the data source.
Database Info
•
Path
The name, including the full path, of the
database to which you want to connect.
•
Visual FoxPro Database
Connect to a Visual FoxPro
database (dbc file) and to all the tables and local views
in the database.
•
Free Table Directory
Connect to a directory of free
tables, that is, tables not associated with any particular
dbc file.
Driver Settings
•
Collating Sequence
Select the collating sequence
that you want to use. The collating sequence determines
the sequence in which the fields sort.
•
Exclusive
Select this check box so that the driver
opens the Visual FoxPro database exclusively when you
access data using this data source. Other users cannot
access the database or the tables in the database while
the database is opened exclusively. Tables within the
exclusively opened database are opened as shared.
This option is not valid when you select the Free Table
Directory option.
•
Fetch data in background
Select this check box to
fetch records in the background (progressive fetching).
Otherwise, ColdFusion waits until all records in the
result set are fetched.
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...