I'm using FMPro 16 on a Mac.
Mac OS 10.12.5
I've written the following simple INSERT script which worked previously and is now giving the above error message.
INSERT into basictest (Forename, Surname)
VALUES (‘David’, ‘Lewis’)
I'm using the ODBC Manager.app plugin
It's a locally hosted file.
ODBC/JDBC sharing is on for all users
I'm doing this in the SQL text, not the Calculated SQL text using Execute SQL.
Any advice on how to get this error corrected or am I going about the INSERT all wrong?