I'm working on a project (not in production yet) that uses the OraOledb provider from Oracle odac 11.2 release 4.
It's worked fine up until now, when I trying to update a column MODIFIED_DATE with the current date. I'm getting:
Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
The tableadapater is using optimistic concurrency. Right now it's basically a single user database. If I switch providers, I don't get this error.
Has anyone seen this?
I haven't seen that, but ORAOLEDB and DATES certainly sets off a bell. Check this if you haven't already:
220.127.116.11 Date Formats
Hope it helps,