Share via


SQLConfigDataSource (Text File Driver)

Note

This topic provides Text File 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
CHARACTERSET For the Text driver, OEM or ANSI.
COLNAMEHEADER For the Text driver, indicates whether the first record of data will specify the column names. Either TRUE or FALSE.
DEFAULTDIR The path specification to the directory.
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. 27 (Text)
EXTENSIONS Lists the file name extensions of the Text files on the data source.

This sets the same option as Extensions List in the setup dialog box.
FIL File type Text
FILETYPE File type for the Text driver (Text).
FORMAT For the Text driver, can be FIXEDLENGTH, TABDELIMITED, CSVDELIMITED (by a comma), or DELIMITED() (by the special character specified in the parentheses). The special character is one character in length and can be in character, decimal, or hexadecimal format.
MAXSCANROWS The number of rows to be scanned when setting a column's data type based upon existing data.

For the Text driver, you can enter a number from 1 to 32767 for the number of rows to scan; however, the value will always default to 25. (A number outside the limit will return an error.)

This sets the same option as Rows to Scan 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.