VB & Database, ADO not releasing row level lock after .Update

ADO not releasing row level lock after .Update

Author	Message
James Wilso #1 / 3	ADO not releasing row level lock after .Update I am using SQL Server 7 with ADO 2.5. I am opening a recordset with the following code: Set rst = New ADODB.Recordset With rst .CursorLocation = adUseServer .CursorType = adOpenDynamic .LockType = adLockPessimistic .Open "Select * from tblLibraryIndexPoint Where id = 1", Conn End With When I call rst!Name = 'John' the record is been locked (which is correct). However when I call rst.Update the lock is not been released. It is not released until I close the recordset. I have tried using different isolation levels on the connection object. Does anybody know why and how I can force the lock to be released without closing the recordset?
Sat, 11 Jan 2003 03:00:00 GMT

D Evenso #2 / 3	ADO not releasing row level lock after .Update Have you tried just moving to the next record? Quote: > I am using SQL Server 7 with ADO 2.5. I am opening a recordset with the > following code: > Set rst = New ADODB.Recordset > With rst > .CursorLocation = adUseServer > .CursorType = adOpenDynamic > .LockType = adLockPessimistic > .Open "Select * from tblLibraryIndexPoint Where id = 1", Conn > End With > When I call rst!Name = 'John' the record is been locked (which is correct). > However when I call rst.Update the lock is not been released. It is not > released until I close the recordset. I have tried using different isolation > levels on the connection object. > Does anybody know why and how I can force the lock to be released without > closing the recordset?
Sat, 11 Jan 2003 03:00:00 GMT

Brian Mora #3 / 3	ADO not releasing row level lock after .Update I would use SQl Profiler to see what's happening.. will likely make things obvious... -- Brian Moran CrossTier.com MS SQL Server MVP SQL Server Mag Columnist Quote: > Have you tried just moving to the next record? > > I am using SQL Server 7 with ADO 2.5. I am opening a recordset with the > > following code: > > Set rst = New ADODB.Recordset > > With rst > > .CursorLocation = adUseServer > > .CursorType = adOpenDynamic > > .LockType = adLockPessimistic > > .Open "Select * from tblLibraryIndexPoint Where id = 1", Conn > > End With > > When I call rst!Name = 'John' the record is been locked (which is > correct). > > However when I call rst.Update the lock is not been released. It is not > > released until I close the recordset. I have tried using different > isolation > > levels on the connection object. > > Does anybody know why and how I can force the lock to be released without > > closing the recordset?
Sat, 11 Jan 2003 03:00:00 GMT

Page 1 of 1

[ 3 post ]