Domains

  • Thread starter Thread starter Charles A. Lackman
  • Start date Start date
C

Charles A. Lackman

Hello,

I have a made client application that adds records to a database on a
domain. Every now and then the database will create duplicate records. I
have closely checked the code and have not seen anyreason for this to be. I
am using parameters and using ExecuteNonQuery to update the database with a
connection object that is directed to the database on a domain.

Any idea why this is happening and if so what is a good work-around?

Thanks,

Chuck
 
Chuck:
More information is necessary for understanding the problem and attempting
to solve the issue. Code samples are always a good place to start but what
type of client are you using? Windows Forms? ASP.NET? Which DBMS are you
using? SQL Server? Oracle? DB2? Each implementation technology provides
its own set of nuances that need to be addressed.

You said that you checked the code and didn't see any reason for the
symptoms to be present. What you didn't say is which code you checked. Did
you check just your ADO.NET code? Did you check only the code in any stored
procedures that may be present? How about trigger code?

Have you been able to identify any trend in the data that is duplicated?
The trend may not be a data trend but may be a user trend. For example, if
this is an ASP.NET application and the problem only surfaces when a user is
connected via dial-up.

Knowing the answer to these questions will help you get an answer. One
thing that is certain however, is that databases don't arbitrarily create
rows on their own. Something has to instruct them to do so.
 
Back
Top