Hi all,
Is there a problem with VFP7 OLEDB provider when using recordset.Update method in an ASP? We get an error when trying to set a value in the first field: rs.field("username")="sam"
Message says something like "...either provider cannot process request or change locking method." We've tried unsuccessfully to get past this one.

Also, using ODBC in VFP6 and the DSN in the same ASP has the intermittent error when doing rs.update "Query-based updated failed..." and we can't figure this one out, either.

Can anyone can help on either approach?
TIA,
Bill