I don't think you can change the ODBC setting to read only. It is what it is, just a connection into the database.
You should add the users to a Database Roll and grant the Roll SELECT permissions to the Table or View. They will not be able to modify the data.
thx
A nod is as good as a wink to a blind bat.