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

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.

Advanced ColdFusion Administration
Advanced Data Source Management

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.