Connect to Microsoft Visual FoxPro database

If you run ColdFusion on a Windows NT platform, you can configure a Microsoft Visual FoxPro database as a data source using ODBC or OLE DB drivers. To complete the connection:

  1. Select options as described in the following table. For the steps involved in configuring your data source, see Configure ODBC data sources.

 

Field

Description

Default

Data Source Name

This field displays the name you entered on the main Data Sources page. You can edit it here.

Filled

Description

Enter a brief description about the data source.

Blank

Database Info

Click Browse Server to locate and enter the path and filename of the database to which you want to connect.

Blank

Select one of the available options:

Visual FoxPro Database (.DBC) if you are connecting to a Visual FoxPro database and to all the tables and local views in the database.

 

Free Table if you are connecting to a directory of free tables where the tables are not associated with any particular .dbc file.

 

Note: If you select this option, the Exclusive Driver Setting is not valid.

FoxPro

Driver Settings/Collating Sequence

The collating sequence determines the order in which fields are sorted. From the drop-down list, select a sequence. Your language version of the operating system supports sequences that you see in the list.

Machine

Driver Settings/ Exclusive

Enable this option if you want the driver to open 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.

 

Note: This option is not valid if you select the Free Table Directory option.

Disabled

Driver Settings/
Fetch Data in background

Enable this option if you want to use progressive fetching, in which records are fetched in background processing.

 

If you disable this option, then ColdFusion waits until all records in the result set are fetched.

Disabled

 

  1. Click Create to save the configuration.

Related topics