Hi,

I am using VB and Oracle 8i, when I tried to drop all connection and record locking by issueing

Set rs = nothing and
Set class = new Class....

vb is still having the connection thus having the record locked which I issued a Select for Update but have not commited or rollback. However, when I use the above to drop the connection when connected to SQL, all connections are gone. What can I do to achieve this result in Oracle?

Thanx.