13.14 General ODBC Driver Limitations
ODBC drivers may impose limitations on the SQL grammar if single-tier configuration is used, e.g. a driver for ISAM file. Otherwise in the multiple-tier configuration the database server will process the SQL.
Some examples of the limitations are:
- The NOT NULL constraint in the CREATE TABLE statement may not be not supported.
- A maximum of 40 AND predicates is supported.
- The CREATE INDEX statement is not supported for Microsoft Excel or Text drivers.
- Views are not supported by the Btrieve, dBASE, Microsoft Excel, Microsoft FoxPro, Paradox or Text driver.