ODBC (32-bit) Connector Service Release Notes Version 1.1.11793.0 (31 Jan 2024) --------------------------------- - Update dependencies. Version 1.1.11166.0 (16 Nov 2023) --------------------------------- - Update dependencies. Version 1.1.10973.0 (12 Oct 2023) --------------------------------- - Update dependencies. Version 1.1.10891.0 (20 Sep 2023) --------------------------------- - Defer database connection attempts for schema validation quickly after an initial database connection attempt has failed. This ensures that database connection timeouts do not accumulate when multiple tasks are started that required schema validation for automatically created tables (deferred connection attemps are already used for data sink connections). - Log a health check error after 2 minutes without successful health check. - Increase timeout for removing stale data sinks or data sources from 2 minutes to 30 minutes. - Log connection error delay and query processing times. Version 1.1.10731.0 (04 Sep 2023) --------------------------------- - Fix potential "duplicate key" error when starting tasks that contain multiple "process" topics. Version 1.1.10519.0 (26 Aug 2023) --------------------------------- - Update dependencies. - Deploy SBOM. - Add option allowing Update or Custom queries not to update any data. Version 1.1.10084.0 (03 Aug 2023) --------------------------------- - Update dependencies. Version 1.1.9923.0 (27 Jun 2023) --------------------------------- - Fix log file rotation. Log files are rotated daily and kept for 31 days. - Update dependencies. Version 1.1.9298.0 (27 Feb 2023) --------------------------------- - Update shared libraries and dependencies. Version 1.1.9019.0 (20 Feb 2023) --------------------------------- - No longer retrying queries that have failed unless queries have failed due to a connection error. This prevents retries of queries that may never succeed, because, for example, there is a syntax error in the query or table field data types are incompatible. Version 1.1.8931.0 (13 Feb 2023) --------------------------------- - Update shared libraries. Version 1.1.8195.0 (31 Jan 2023) --------------------------------- - Update shared libraries and dependencies. Version 1.1.7948.0 (23 Jan 2023) --------------------------------- - Improve MySQL ODBC driver compatibility. Version 1.1.7821.0 (14 Jan 2023) --------------------------------- - Reduce database connection test timeout. Version 1.1.7684.0 (06 Dec 2022) --------------------------------- - Add option to allow "Process Queries" to return empty or partial results. - Improve automatic consistency updates when changing topic access mode. Version 1.1.7541.0 (05 Nov 2022) --------------------------------- - Support Task Import/Export and extended Project Import/Export. Version 1.1.6948.0 (12 Aug 2022) -------------------------------- - Support automatic delete of old samples for Write Mode "Insert". - Fix: Ensure that a topic's derived table name is updated on rename. Version 1.1.6875.0 (01 Aug 2022) -------------------------------- - Support Copy and Paste for tags. Version 1.1.6329.0 (17 Jun 2022) -------------------------------- - Target framework .NET 6. Version 1.0.5229.0 (02 May 2022) -------------------------------- - Avoid launching unused process when configured for remote administration being IIS. Version 1.0.5201.0 (27 Apr 2022) -------------------------------- - Support advanced database settings "auto-table prefix", "timestamp time zone", "prefer subsecond precision". Version 1.0.5187.0 (22 Apr 2022) -------------------------------- - Add extended suppport for SAP HANA. - Add extended support for IBM DB2. - Dynamically extend table by adding columns for values that arrive late. - Create primary key on sample ID column for 'Auto' topics in Oracle. Version 1.0.5182.0 (21 Apr 2022) -------------------------------- - Fix handling of invalid characters when adding missing columns for 'Auto' topics. - Fix field browser not showing fields for Oracle and Postgresql. Version 1.0.5164.0 (19 Apr 2022) -------------------------------- - Support adding missing columns for 'Auto' topics. Version 1.0.5017.0 (07 Apr 2022) -------------------------------- - Support import/export of topics in JSON format. Version 1.0.4079.0 (24 Sep 2021) -------------------------------- - Fix: When a task is started and all values to be inserted are initially null or invalid and no default sample datetime field is selected to be stored, then the start of the task may fail with "syntax error", and the task can only be started once at least one valid value is present. The fix allows starting the task even if there is no initial valid data; no data is inserted until at least one valid value is present. Version 1.0.4045.0 (10 Sep 2021) -------------------------------- - Add 'process' topic access mode to simplify recipe transfers and batch processing. Core service version 1.0.4024 or later required. Version 1.0.4019.0 (07 Sep 2021) -------------------------------- - Fill array elements with NULL if an unexpected scalar value is received instead of the expected array value to avoid 'syntax error' messages. Version 1.0.3975.0 (03 Sep 2021) -------------------------------- - Add support for quoted identifiers in database queries. - Add support for identifiers enclosed in square brackets in database queries. - Add support for identifiers enclosed in backticks in database queries. - Add diagnostics query log feature. - Add "custom read query" feature. - Support renaming of tags within a topic (Core service version 1.0.3961.0 or later required). - Minor bug fixes. Version 1.0.3964.0 (25 Aug 2021) -------------------------------- - Fix "Update" Write Mode error encountered with some databases ("update" in custom write query was unaffected). Version 1.0.3934.0 (20 Aug 2021) -------------------------------- - Add support for headless deployment and remote administration. - Update shared libraries. Version 1.0.3783.0 (03 Aug 2021) -------------------------------- - Extend support for headless deployment and remote administration. Version 1.0.3654.0 (22 Jul 2021) -------------------------------- - Fix: When the connection to a database is lost in a task that uses input topics originating from different databases then ensure that only the topic tag values of the disconnected database are marked as 'bad'. Requires Dataristix Core service version 1.0.3650 or later. - Fix: When used as input and the database connection is lost, then resend values after the connection is re-established. Version 1.0.3542.0 (15 Jun 2021) -------------------------------- - Support tag names starting with a digit by prefixing the derived column name for Insert or Update queries with an underscore character. - Validate column names for Select queries. Version 1.0.3479.0 (07 Jun 2021) -------------------------------- - Add support for user access control. - Run service as "Local Service" instead of "Local System". - Reduce maximum precision for timestamps to full milliseconds for greater compatibility with "datetime" types. Version 1.0.3174.0 (13 May 2021) -------------------------------- - Handle custom queries executing stored procedures that do not insert or update any rows. Version 1.0.3042.0 (26 Apr 2021) -------------------------------- - Fix placeholder substitution for placeholders that are at the end of a query. - Interpret result code zero as success for stored procedure custom queries starting with 'exec '. Version 1.0.2936.0 (16 Apr 2021) -------------------------------- - Reduce memory usage. Version 1.0.2509.0 (25 Jan 2021) -------------------------------- - Ensure that data source sends notification if an initial value is null. Version 1.0.2472.0 (14 Jan 2021) -------------------------------- - Update shared libraries to latest version extending timeouts for the underlying data sink / data source to prevent task connections becoming "stale". Version 1.0.2269.0 (20 Nov 2020) -------------------------------- Update shared libraries to latest version. Version 1.0.2187.0 (11 Nov 2020) -------------------------------- - Sanitize derived table names. - Remove duplicates from reported ODBC error messages. Version 1.0.2025.0 (03 Sep 2020) -------------------------------- - An index on the "sample_datetime" field is now automatically added for new database tables that are created for generic topics with the "sample_datetime" option ticked. Version 1.0.2014.0 (02 Sep 2020) -------------------------------- - Fix: Prevent loading other projects while there are live value sessions. Version 1.0.1920.0 (26 Aug 2020) -------------------------------- - Update shared libraries for compatibility. Version 1.0.1674.0 (25 May 2020) -------------------------------- - Change internal test only. Version 1.0.1624.0 (18 May 2020) -------------------------------- - Change "tags no longer subscribed" message level from Warning to Info. Version 1.0.1572.0 (27 Apr 2020) -------------------------------- - Support deferred ack/nack for pending output connector updates. Version 1.0.1538.0 (14 Apr 2020) -------------------------------- - Fix handling of null strings and arrays of null strings. Version 1.0.1525.0 (08 Apr 2020) -------------------------------- - Fix potential issue with initial default value assignment for newly created topics. Version 1.0.1485.0 (06 Apr 2020) -------------------------------- - Non-functional change to fix message text. Version 1.0.1428.0 (30 Mar 2020) -------------------------------- - Ensure consistent sample timestamps for datasets sent to multiple output topics. Version 1.0.1395.0 (27 Mar 2020) -------------------------------- - Improved start-up logging. Version 1.0.1382.0 (23 Mar 2020) -------------------------------- - Support creating an empty project. Version 1.0.1346.0 (16 Mar 2020) -------------------------------- - Improve database connection failure handling performance. - Minor bug fixes and improvements. Version 1.0.1242.0 (09 Mar 2020) -------------------------------- - Improved error message formatting when 'create table' fails. Version 1.0.1199.0 (02 Mar 2020) -------------------------------- - Fix initial installation, start-up and module detection issues.