I have an Web ASP based system that uses Visual FoxPro to retrieve and update data in a Progress database via ODBC. The problem I am having is occassionally I get record locking problems. This is most often caused when a normal progress user is locking a record required by a read request from an ASP page.
Do I need two ODBC connections one for read access one for write access?
Can I set the Default Isolation via code at runtime?
Are there any other options?
Do I need two ODBC connections one for read access one for write access?
Can I set the Default Isolation via code at runtime?
Are there any other options?