Share via


SQLConfigDataSource (dBASE Driver)

Note

This topic provides dBASE Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.

The SQLConfigDataSource function that is used to add, modify, or delete a data source dynamically uses the following keywords.

Keyword Description
COLLATINGSEQUENCE The sequence in which the fields are sorted.

The sequence can be: ASCII (the default) or International.

This sets the same option as Collating Sequence in the setup dialog box.
DEFAULTDIR The path specification to the directory.
DELETED For the dBASE driver, specifies whether or not rows that have been marked as deleted can be retrieved or positioned on. If set to 1, deleted rows are not displayed; if set to 0, deleted rows are treated the same as non-deleted rows.

This sets the same option as Show Deleted Rows in the setup dialog box.
DESCRIPTION A description of the data in the data source.

This sets the same option as Description in the setup dialog box.
DRIVER The path specification to the driver DLL.
DRIVERID An integer ID for the driver.

21 (dBASE III)

277 (dBASE IV)

533 (dBASE 5.0)
FIL File type dBase III, dBase IV, or dBase 5
PAGETIMEOUT Specifies the period of time, in tenths of a second, that a page (if not used) remains in the buffer before being removed. The default is 600 tenths of a second (60 seconds). Note that this option applies to all data sources that use the ODBC driver.

This sets the same option as Page Timeout in the setup dialog box.
READONLY TRUE to make file read-only; FALSE to make file not read-only.

This sets the same option as Read Only in the setup dialog box.
STATISTICS For the dBASE driver, determines whether table size statistics are approximated. Note that this option applies to all data sources that use the ODBC driver.

This sets the same option as Approximate Row Count in the setup dialog box.
THREADS The number of background threads for the engine to use. This value is 3 and cannot be changed.

This sets the same option as Threads in the setup dialog box.