It seems absurd... (DB question)

[Xmas79]

But I can't get an error . Yes, I want the DBConcurrency error, but I can't get it! When I establish two different connection with a database, make the same query, modify the data with different values and try to update, I get no error.
Why? Are the two different connections?

Help, please... Thx

[Lunatic3]

Did you add the dataadapter at desing time? if so did you checked 'Use Optimistic Concurrency' ?

[DevGrp]

Do this. Start the program twice, then get the data from both programs. Change and update one program, then change and update the second program. You should get an error. I did a project to produce a DBConcurrency exception, and I did it like the above.

[Xmas79]

I did this:

dim Da1 as OleDbDataAdapter
dim Da2 as oleDbDataAdapter
dim ds1 as DataSet
dim ds2 as DataSet
 
Da1 = New OleDbDataAdapter(TheSameQuery, myConnection)
Da2 = New OleDbDataAdapter(TheSameQuery, myConnection)
 
Da1.Fill(ds1,mytable)
Da2.Fill(ds2,mytable)
 
ds1.tables(0).rows(0)(0)=10
ds2.tables(0).rows(0)(0)=15
 
da1.Update(ds1,mytable)
da2.update(ds2,mytable) ' Here's where I GET the error

In the code above I GET the error, but since I'm remoting this object, I can't use these lines don't know why:

Da1 = New OleDbDataAdapter(TheSameQuery, myConnection)
Da2 = New OleDbDataAdapter(TheSameQuery, myConnection)

To make it working I had to change in:

Da1 = New OleDbDataAdapter(TheSameQuery, myConnectionString) 'Instead of myConnection
Da2 = New OleDbDataAdapter(TheSameQuery, myConnectionString) 'Instead of myConnection

Now I DON'T GET the error... Please try...

[Xmas79]

Anyone, please?

Thx...