MDAC 2.5 SDK - ODBC Desktop Database Drivers
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. |