Re: Concurrency violation

On Thu, 18 Sep 2008 09:50:08 -0400, Zhuo Li wrote:

Hi, I get this error when I try to save a datatime field to the database
using OdbcDataAdapter.Update method.
oAdapter.UpdateCommand.CommandText is like: "update aTable set
effetive_from =? where primarykey=?"

The parameter related to this field is like:

oAdapter.UpdateCommand.Paramteres.Add(new
OdbcParameter("effective_from", Odbctype.datetime, 8, "effective_from");

The database is Sybase ASA 9.0. The column effective_from's type is
datatime in the database.

Any suggestions/ideas?

Thanks, Zhuo

The simplest way is to disable concurrency checking. In your database
set up click on the table and then check the settings, advanced from
memory and remove it. There are multiple descriptions of how to handle
the problem (generally with autonumber primary keys) but if you are using
a database exclusively it is not worth the effort

Ken
.

Relevant Pages

  • Concurrency violation
    ... I get this error when I try to save a datatime field to the database ... oAdapter.UpdateCommand.CommandText is like: "update aTable set effetive_from ... The database is Sybase ASA 9.0. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Multiple databases - best performance scenario
    ... My company has the need to manage data for multiple customers. ... Multiple small physical servers connected to SAN ... When I'm using the word database ... You might consider checking licensing costs at the oracle store ...
    (comp.databases.oracle.server)
  • Re: Rails app organization question
    ... I -really- like Rails, though. ... Have one instance of the app and somehow allow it to use different databases depending on the user's login. ... Have multiple instances of the app running on virtual servers, similar to how cPanel sets up accounts for multiple hosts -- each host has its own directory, MySQL database, and so on. ...
    (comp.lang.ruby)
  • Re: Merging Data Dynamically
    ... not mind multiple back-ends. ... But if you had told me your Sailing Clubs are all owned by ... then loop through all the tables to detach them from 1 back end database ... sudden addition of Removals5 and create a linked table for it. ...
    (comp.databases.ms-access)
  • Re: Conversion to 2007
    ... All I know Iis have multiple tables used to store data and multiple tables ... Sometime I used multiple queries to filter the information or shape reports ... Office Pro 2007 and hope it will work as well with office 2003 ... so a well-designed database may work without modification in A2007. ...
    (microsoft.public.access.tablesdbdesign)
Loading