I need to do record locking in classic ASP. I was able to get it working in ASP.NET using System.Transactions code on the same system that the classic ASP code is running. The problem is protecting (linearizing access to) the classic read-modify-write cycle on a single record in an SQL Server 2012 database table.
Conceptually I need to do the following simple steps:
select cur_value from value_tbl where id_val = 1;
next_value = cur_value + 1
update value_tbl set cur_value = next_value where id_val = 1;