ODBC (32-bit) Connector Service Release Notes 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.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 UA Office Link 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.