I am using ADO 2.6 with oracle's OLEDB provider for oracle (not the microsoft one).
Whatever value I set for the CommandTimeout property of the connection, or of a command object, no timeout occurs.

It seems that the OLEDB provider did not implement the CommandTimeout property.

When an update statement is executed, and runs against a lock, the statement waits untill the lock is resolved.

I want to inform the user that the data is locked, and that he should try it at a later moment, but when the Execute method doesn't timeout, I can't do that.

Does anybody know how to cancel the update statement when it times out waiting for a recordlock?