User Guide

Chapter 4: Managing Data Sources 89
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” on page 82.
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” on page 82 for more information.
Performance Row Limit — The number of rows the driver retrieves from the
server for a fetch. Enabling this option can increase performance
by reducing network traffic.
Disable database cursors for Select statements — Determines
whether database cursors are used for Select statements. In
some cases performance degradation can occur when
performing large numbers of sequential Select statements
because of the amount of overhead associated with creating
database cursors.
Customization Enable Password Encryption from Open Client Library to
Server — Determines whether password encryption can be
performed from the Open Client Library to the server.
MERANT MS SQL Server ODBC Options (Continued)
Option Description
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.