BUG: Optimistic Concurrency Error with DYNAMIC Cursors (158164)
The information in this article applies to:
- Microsoft SQL Server 6.5
- Microsoft Open Database Connectivity 2.5
This article was previously published under Q158164
BUG #: 16136 (6.50.201)
SYMPTOMS
When you attempt to call the open Database Connectivity (ODBC) function
SQLSetPos() multiple times with the SQL_UPDATE option on a DYNAMIC cursor,
you may incorrectly receive the following error message:
szSqlState = "01S03", *pfNativeError = 16934,
szErrorMsg = "[Microsoft][ODBC SQL Server Driver][SQL Server]
Optimistic concurrency check failed, the row was modified outside of this cursor"
WORKAROUND
To work around this problem, switch to a keyset cursor on SQL Server 6.5
Service Pack 1 or later. To obtain SQL Server 6.5 Service Pack 1, see the
following article in the Microsoft Knowledge Base:
154549
: INF: How to Obtain SQL Server 6.5 Service Pack 1
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5 and Microsoft Open Database Connectivity version 2.5. We are
researching this problem and will post new information here in the
Microsoft Knowledge Base as it becomes available.
Modification Type: | Major | Last Reviewed: | 10/16/2003 |
---|
Keywords: | kbBug kbinterop kbother kbusage KB158164 |
---|
|