I have now got this working using the ODBC Driver 17 for SQL Server. I think there should be some updated guidance on how to set this up, from start to finish, as the current manual is a bit vague.
Hi, Paul.
Sounds like you're talking about REST API. And that your are overwriting data with older values if B managed to read record before A finished to update it. Classic conflict resolution ...