Hello,
Did you succeed in creating a connection?
I tried both options:
1) Connection.TxOptions.ReadOnly = True (and Connection.UpdateOptions.ReadOnly = True)
2) MSSQLDriverLink.ODBCAdvanced := 'ApplicationIntent=ReadOnly' (also tried the full connection string)
However, the connection is still not created read-only 😞