This section describes issues associated with ODBC development.
SQLPrepare() and SQLExecDirect() Calls Fail for Read-Only Connections (ODBC)
When connecting with read-only access, the
SQLPrepare() call fails due to a restriction in Exadata Express. The
SQLExecDirect() call also fails for the same reason.
Use write access instead of read-only access. There are a number of ways to setup the write access in an ODBC application.
On Linux, set
On Windows, uncheck Read-Only Connection in utility
In an application, you can do one of the following:
DBA=Ras the parameter in SQLDriverConnect() function call.