Hey Guys!!!
I don't know if this one i'm going to ask is simple for all of you or not, im
Previously build a whole school system for a school here in my place, the
school is equipped from admission system to accounting system using MS SQL 2000
and delphi to get it work on.
At first the system went fine, but when the grading system has been heavily
used by more than 60 PC each day, excluding the pc that is been using the
admission or accounting system etc. the database or the programs displays
warning messages 'Database Deadlock,..... you have been chosen as the victim,
rerun transaction' every often.
I have already researched about it and i found out that the messages is and
Edatabase Error, and is caused by a specific condition when two or more
processes are each waiting for each other to release a resource, or more than
two processes are waiting for resources in a circular chain.
(http://en.wikipedia.org/wiki/Deadlock)
I already understand what it meant by my problem is still not solved, ..... i
don't know how remove that deadlock error or even that serialization. maybe you
guys can help me get rid of it somehow, i use more that 10 different programs
in one database. thanks and much appreciated if you could help me
Commander Charlie Adrian Parker™
[Non-text portions of this message have been removed]
