MariaDB [kmantest]> show create table odbc_except \G;
*************************** 1. row ***************************
       Table: odbc_except
Create Table: CREATE TABLE `odbc_except` (
  `EMPL` varchar(4) NOT NULL,
  `ITEM` varchar(13) NOT NULL,
  `ORDERNO` varchar(13) NOT NULL,
  `IDEN` varchar(7) DEFAULT NULL,
  `LOCAT` decimal(15,0) DEFAULT NULL,
  `JACTDATE` decimal(15,0) DEFAULT NULL,
  `COMMEN` varchar(26) DEFAULT NULL,
  `PROGRAM` varchar(13) DEFAULT NULL,
  `MADEBY` varchar(4) DEFAULT NULL,
  `ACTTIME` varchar(6) DEFAULT NULL,
  `LOGGEDIN` varchar(13) DEFAULT NULL,
  `NOTES` varchar(401) DEFAULT NULL,
  PRIMARY KEY (`EMPL`,`ORDERNO`,`ITEM`)
) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=KMANTEST' `table_type`=ODBC `tabname`=EXCEPT
1 row in set (0.00 sec)

ERROR: No query specified

MariaDB [kmantest]> UPDATE ODBC_EXCEPT SET EMPL='',ITEM='', ORDERNO='',LOCAT=0,JACTDATE=0,COMMEN='' ,PROGRAM='',MADEBY='',ACTTIME='',LOGGEDIN='',NOTES='' WHERE JACTDATE<158654 and EMPL='JEC';
ERROR 2013 (HY000): Lost connection to MySQL server during query
MariaDB [kmantest]> DELETE FROM ODBC_EXCEPT WHERE JACTDATE<158654 and EMPL='JEC';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    2
Current database: kmantest

ERROR 2013 (HY000): Lost connection to MySQL server during query