Configuration topics > BDE configuration settings > Drivers settings

To configure the way dBASE and FoxPro tables are created, sorted, and handled, choose dBASE as the driver name on the Configuration page of the BDE Administrator or create or select a STANDARD alias on the Databases page that uses DBASE as the Default Driver type.

To change a setting, highlight the desired configuration parameter. Delete the old value and enter a new one in the appropriate text box. You can only change parameters WITHOUT bold labels.

Since FoxPro is an xBASE application, its driver settings are virtually identical to dBASE's except that LEVEL must be set to 25 to read and write a .DBF table in FoxPro format.

In the following table, Parameters lists all tracked parameters for the selected driver type, and their current settings. When the driver is first installed, all values are set to their defaults.

Description briefly notes the purpose of the highlighted parameter.

Parameter	Description
VERSION	Internal version number of the dBASE driver
TYPE	Type of server to which this driver helps you connect. Can be SERVER (SQL server) or FILE (standard, file-based server).
LANGDRIVER	Language driver used to determine table sort order and character set. [available drivers] US. Default: 'ascii' ANSI (DBWINUS0)
LEVEL	Type of table format used to create dBASE temporary tables. Can be 7 for dBASE 7.0 table format, 5 for dBASE 5.0 table format, 4 for dBASE 4.0 table format, or 3 for dBASE III and dBASE III PLUS table formats. Use 25 for FoxPro. Default: 7 Note: When accessing dBASE level 7 tables, the driver level must be set to 7.
MDX BLOCK SIZE	Size of disk blocks dBASE allocates for .MDX files, in bytes. Can be any integer that is a multiple of 512. Default: 1024
MEMO FILE BLOCK SIZE	Size of disk blocks dBASE allocates for memo (.DBT) files, in bytes. Can be any integer that is a multiple of 512. Default: 1024

dBASE and FoxPro driver settings

dBASE and FoxPro driver settings