# Connecting to Visual FoxPro Databases

ColdFusion lets you access Microsoft Visual FoxPro databases from Windows, via ODBC drivers.

## Configuring Visual FoxPro Options (Windows)

If ColdFusion Server is installed on a Windows server, you can configure Visual FoxPro as a ColdFusion data source using any either an ODBC or OLE DB driver. For information about using OLE DB drivers with ColdFusion data sources, see "OLE DB Drivers".

| ODBC: Visual FoxPro Options (Windows)

The following table describes ColdFusion ODBC options for Visual FoxPro data sources. You set these options when you configure a ColdFusion data source. See "Adding Data Sources for ColdFusion" for more information.

Microsoft Visual FoxPro ODBC Options
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 you want to use. The collating sequence determines the sequence in which the fields are sorted.
Exclusive -- When this check box is selected, 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 the "Free Table Directory" option is selected.
Fetch data in background -- When this check box is selected, records will be fetched in the background (progressive fetching). Otherwise, ColdFusion will wait until all records in the result set are fetched.