ODBC, OLE DB (32- and 64-bit).
ODBC with version 16.20 only supports 64-bit.
OLE DB with version 15 only supports 32-bit.
|Driver Configuration Requirements||
Bulk read and write support is available for standard workflows. Bulk write support is available for in-database workflows.
|Type of Support||
Read & Write, In-Database
ODBC Client Version 16.20.32.01
Maximum Columns In Table: 2048
Maximum Column Name Length: 30 Characters
Maximum Row Size: 64256 Bytes (does not include LOB size)
Fixed Numeric is supported in this version of the driver.
Fixed Numeric is transported as a String. DBTYPE_NUMERIC is not supported.
Date, Time, and Timestamp transported as a DBTYPE_STR. Native formats are not standard.
LOB data types can be read from a table but can't be written.