[ODBC] Cursor has not been opened for update

[ingres42]

Hi,

I'm having a problem here with an ODBC connection.
Selects are ok, but write access is failing with "Cursor [name] has not been opened for update".
The driver is not set to read_only and the connection is even opened with ALLOWUPDATE=Y.

The server is 10.1, the client 10.0 - both Windows.
The server is configured to
cursor_update_mode = DEFERRED
cursor_default_open = UPDATE

Any idea what I'm doing wrong? I have no access to the application source code...

[thoda04]

Try issuing for the statement in question, an ODBC SQLSetStmtAttr( hstmt, SQL_ATTR_CONCURRENCY, SQL_CONCUR_VALUES, ...). The ODBC specification says that the default is SQL_CONCUR_READ_ONLY, that the cursor is read-only, and that no updates are allowed.

Hope this helps,
Dave

[ingres42]

How would I change this when I don't have access to the source code? I cannot see if it says "for update".
As mentioned above, the connection is opened with SQL_DATA_SOURCE_READ_ONLY = N and the default cursor mode is UPDATE.

[ThomasAnderson]

Check that the cursor is not defined as read only. Use the FOR UPDATE clause that helps the data base manager to decide whether a cursor is updatable or not.

[ingres42]

Well, again, I have no access to the source code :\
How can I check if it's read only or not? I have the windows odbc trace log. The only thing I see there is "<SQL_DATA_SOURCE_READ_ONLY> == N".
I did look for <SQL_SCROLL_CONCURRENCY> but I can't see (or interpret) if it's set to <SQL_CONCUR_VALUES> or anything...

The very same application runs fine with Oracle and MSSQL.