Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

ODBC and ADO.NET deactivates Snapshot Mode

Details

Detail name	Value
Changelog Number	14096
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0
Fix Versions	Exasol 8.0.0, Exasol 7.1.7
Resolution Date	2022-03-16

Background

Since Exasol 7.1 the Snapshot Mode is used per default.

Description

The default for ODBC and ADO.NET incorrectly deactivates the Snapshot Mode.

Workaround

Set the Snapshot Mode in the session using SQL:

ALTER SESSION SET SNAPSHOT_MODE = 'SYSTEM TABLES';

Fix

The driver does not set any defaults if the user did not specify this in the connection string. If not specified, the connection uses the database default.

Changed behavior

The Exasol ADO.NET and ODBC driver will not set snapshot transactions by default to "OFF" at connect time.