Re: ODBC, NT and Workgroup problem

Posted in 1998

Jun Nolasco — Fri, 23 Oct 1998 23:19:51 -0400 — source: Informix-list mailing list archive (1991-1998)

We already have those two set as the default database setting. But, we still get these errors from time to time. Any other reasons why? Thanks. Jun Nolasco nolasco@inx.net Walter S. Tyszka wrote: > > Perhaps the type of locking used by the datasource is not the issue? > The isolation mode (or concurrency) of the user's process is what you > need to consider. > The sugestion by Mr. Kagel to "SET LOCK MODE TO WAIT n" is one posible > solution. Another would be to "SET ISOLATION TO DIRTY READ". > Then the insert statement will be able to validate any unique constraint > violations. > > -- > Regards, > > Walter S. Tyszka (wstyszka@ingr.com) * Standard disclaimers apply *