I just stumbled purely by accident upon the solution. Despite all documentation referring to:
ApplicationIntent=ReadOnly, that does not work.
But "Application Intent=ReadOnly" (with a space) does work. At least via C++, ADO and MSOLEDBSQL and MSOLEDBSQL19.