System Crash because sql server 2005

Question

0.00/5 (No votes)

See more:

i have a problem i made windows application that run on so many terminal and server placed at one station. When two or more terminal access same data at same time the screen got hang an just crash.

like two terminal generating bill they got bill no at same time an here the problem come.

Posted 21-Jul-11 21:31pm

Member 7925220

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-07-21T21:45:00

Oops! Now, that is probably your fault: but without the database design and relevant code fragments it is difficult to tell exactly what you have done. However, I would be prepared to wager a small amount of money that you are generating your row id's (or similar) yourself and multiuser access is trying to create duplicates...

[edit]"without", Griff, not "with". I need caffeine - OriginalGriff[/edit]

Mycroft Holmes · Answer 2 · 2011-07-21T21:46:00

I suspect you are generating the bill number in the client based on the identity values but you are not storing the record when you get the value. Therefore the next user gets the same value.

You need to do 1 of 2 things:
1 Create and store the record when you get the order number thereby removing it.
OR
2 Only get the order number when all the data is stored. This is by far the recommended method! If you have order lines with the order header then you are going to have to learn about transactions as well!

System Crash because sql server 2005

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0