Export (0) Print
Expand All

SQLConfigDataSource (Text File Driver)

Note 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.

Show:
© 2014 Microsoft