Microsoft Access 32 bit crashes if long varchar columns are imported

Details

Detail name Value
Changelog Number 11652
Type Bug
Status Resolved
Affected Versions Exasol 7.0.0
Fix Versions Exasol 7.1.0, Exasol 7.0.9
Resolution Date 2021-04-19

Description

If the ODBC attribute SQL_ATTR_MAX_LENGTH is set to a very high value the client application may crash.
This is the case for MS Access 32 bit when varchar data longer than 32.000 are transferred.

Workaround

There is no workaround. 

Fix

Using the ODBC attribute SQL_ATTR_MAX_LENGTH works as expected.