SQLGetInfo (Excel Driver)

Article
01/19/2017

Note

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

SQLGetInfo supports the SQL_FILE_USAGE information type. The returned value is a 16-bit integer that indicates how the driver directly treats files in a data source:

SQL_FILE_NOT_SUPPORTED - The driver is not a single-tier driver.
SQL_FILE_TABLE - A single-tier driver treats files in a data source as tables.
SQL_FILE_QUALIFIER - A single-tier driver treats files in a data source as a qualifier.

The ODBC driver returns SQL_FILE_TABLE for theMicrosoft Exceldriver because each file is a table.

SQL_DBMS_VER

ISAM	Version	Format of version numbers
Microsoft Excel	3.0	03.00.0000
	4.0	04.00.0000
	5.0/7.0	05.00.0000
	97/2000	08.00.0000

SQL_FILE_USAGE

SQL_FILE_TABLE (Excel 3.0/4.0)

SQL_FILE_CATALOG (Excel 5.0/7.0)

SQL_MAX_CHAR_LITERAL_LEN

255 (Excel 3.0/4.0/5.0/7.0)

65535 (Excel 97)

SQL_MAX_COLUMN_NAME_LEN

30 (Excel 3.0/4.0)

64 (Excel 5.0/7.0/97)

SQL_MAX_TABLE_NAME_LEN

12 (Excel 3.0/4.0)

31 (Excel 5.0/7.0/97)

SQL_CATALOG_NAME_SEPARATOR

"\" (Excel 3.0/4.0)

"." (Excel 5.0/7.0/97)

SQL_CATALOG_TERM

"Directory" (Excel 3.0/4.0)

"Workbook" (Excel 5.0/7.0/97)

SQL_CATALOG_USAGE

SQL_QU_DML_STATEMENTS | SQL_QU_TABLE_DEFINITION

SQL_TIMEDATE_FUNCTIONS