Looks like you used a recent version of the DataMapper to create your config, but your Connect Servers are older and can’t understand some of the commands in the config.
Try saving your DM Config as an older version (using the File | Save a Copy…" option).
I did not have the Access 64 bit ODBC installed and once this was installed and a 64 bit data source created I was able to do the query in the designer at 64 bit level and skip the database query plugin in Workflow
Yep, the ODBC world can sometimes be confusing because Connect is a 64-bit application and can therefore only use 64-bit ODBC Data Sources, while Workflow is a 32-bit application that can only use 32-bit ODBC Data Sources. Which means that in some cases, you have to create both a 32 and a 64 bit Data Source for the same database if you want to be able to access it from Connect and from Workflow.
In this instance, it would have been useful if Connect / Workflow had been able to report a more meaningful error message, it might have saved you some hassle. I will raise that point with our R&D team.