Tuesday, April 19, 2011

System.Data.Odbc.OdbcException: ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Failure getting record lock on a record from table PUB.#####.

Solution: Add the no-lock statement to each select statement.

SELECT * FROM PUB.##### WITH(NOLOCK)

1 comment:

Jeff Castelloe said...

This used to work fine for us but since we updated to the 10.2b odbc driver the nolock feature does not seem to work. Any ideas?