Optimistic Concurrency causing Data Adapter Configuration Wizard Error

[Graham Long]

Hi,

Here's a mystery:

I have a simple database with a primary key and 25 columns. When I
create a data adapter using the wizard, I get the message:

"There were errors configuring the data adapter."

for the UPDATE and DELETE statements only. By experiment, I've found
that these errors are generated only when the "Use Optimistic
Concurrency" radio button on the Adavanced options of the wizard is
selected.

When I did the same thing for the database when it had only 3 columns,
there are were no problems.

Any ideas?

The primary key is an INT type and the other fields are "text" type.

 

[Mary Chipman]

You might want to think about *not* pulling down 25 columns for
update. If you must, then add a timestamp column to the table
(assuming that you are using SQL Server) and see if that helps. If
your entire database consists of only one, denormalized table, then
you also might want to think about normalizing it.

--Mary