Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |