VB6.0 > ADO > OLEDB : Lock Modes

Posted in 2000

Andy McColl — Wed, 26 Jan 2000 13:01:10 -0000 — source: Informix-list mailing list archive (1991-1998)

Does anyone know how to effect the timeout of a process waiting to receive a row that is locked by a different process? (i.e. on our Unix based apps the wait is infinite, but on VB apps we seem to be experiencing a timeout and a returned ADO error) Thanks in advance

↪ replying to Andy McColl

Leopold The Cat — Wed, 26 Jan 2000 11:45:03 -0800 — source: Informix-list mailing list archive (1991-1998)

Looks like Informix OLEDB believes in waiting for locks in transactions (and you can set the timeout) and does not believe in it in auto-commit mode. Can you try to use transaction? Leopold Andy McColl <andy.mccoll@vernons.co.uk> wrote in message news:948891896.18273.0.nnrp-11.d4f05361@news.demon.co.uk... > Does anyone know how to effect the timeout of a process waiting to receive a > row that is locked by a > different process? > > (i.e. on our Unix based apps the wait is infinite, but on VB apps we seem to > be experiencing a timeout > and a returned ADO error) > > Thanks in advance > >