I am building an application which has to extract data from a Progress DB.
This extraction works fine most of the time.
But from time to time another user is locking a record which I just have to read.
The user and password I use has by default only read access …
But when another user has a record open my application does not work anymore and I get an error that it was not possible to get a lock …
I searched and found the “WITH (NOLOCK)” option in queries but that does not work (error).
Is it possible to define a connection that is READ ONLY?
Can anybody help me?