Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unhappy Unanswered: transaction doesn't work

    I use odbc to connect to MS SQL Server
    After start transaction I add new records
    (sql enterprice manager->Management->Locks/Process ID shows that new Process establishes after every insertion)
    After commit all processes are still alive

    When I try start new transaction I get dead lock (on these processes which I didn't estaplish manually)

  2. #2
    Join Date
    Nov 2002


    Problem was when after starting transaction new cursors were created.
    Before insertion cursor has to be closed
    That helped

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts