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.