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

    Unanswered: odbc - start transaction - open query - new process

    I try to do:
    - open transaction
    - open cursor nr 1
    - open cursor nr 2
    - insert
    - commit

    for cursor nr 2 and for insert new connection establishes

    When next time I try to do the same I gen dead lock

    What for is this new connection (what should I do - it makes probles)
    Any suggestions?

  2. #2
    Join Date
    Nov 2002
    I'm not sure, just guessing (not too great with cursors)
    are you closing your cursors?

  3. #3
    Join Date
    Nov 2002

    yes and not

    I close them but after insert

    When I close cursor befour open next curosr or insert there is no problem. It happens only during transaction

    Thx for replay

Posting Permissions

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