ODBC supports the concept of a read-only connection. For information about ODBC read-only connections, see SQLSetConnectOption in the Microsoft ODBC 2.0 Programmer's Reference and SDK Guide. If the gateway or DBMS supports a read-only connection, IDS_ACCESS_MODE_OFFSET strings should be set to the appropriate SQL statement.
If these strings are empty, the SQLSetConnectOption SQL_ACCESS_MODE option is ignored by the Open Data Services ODBC driver. Note that the ODBC definition of read-only connections is not necessarily intended to preclude non-selects, but is intended to optimize locking for selects only. An error can be returned on non-selects if the gateway or DBMS needs to return an error, but it is not required.