DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Dead locks

  1. #1
    archana Guest

    Dead locks


    How to avoid dead locks when calling stored procedures thr' VB6 ?




































































  2. #2
    Dennis Guest

    Re: Dead locks


    "archana" <arc_n@usa.net> wrote:
    >
    >How to avoid dead locks when calling stored procedures thr' VB6 ?
    >


    You need to do some reading on deadlocks. VB has no particular role. I expect
    if you have a deadlock, it would occur running the stored proc(s) outside
    of VB. A deadlock occurs when two processes try to use resources locked by
    the other. Neither one can "move". A good remedy for deadlocks is to always
    update tables in the same sequence in all processes.

    A more likely scenario is that you are experiencing a lock. When you do database
    modifications, rows are locked pending the completion of the transaction,
    either commit or rollback. Is your stored proc accessing the same rows more
    than once?

    Dennis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center