Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Unhappy Unanswered: Problem with Rollback when i have a disconnection.

    My english is bad, sorry !

    The server run on Windows XP and i have activated InnoDB.
    To access MySql I use MyODBC with VB 6.

    When i start a transaction with MySql, if i lose my connection during transaction, the server doesn't automatically rollback the transaction.
    I don't understand why !

    Can you help me ?

    Thanks,

    Morpheus.

  2. #2
    Join Date
    Sep 2003
    Posts
    2

    Smile Re: Problem with Rollback when i have a disconnection.

    Hi Morpheus,
    Just wondering if you ever got an answer to your question. I am having the same problem and can't find the answer anywhere.
    Thanks,
    Marina.

  3. #3
    Join Date
    Jul 2003
    Posts
    30

    Re: Problem with Rollback when i have a disconnection.

    This may be a stupid question, but do you have AUTO_COMMIT turned off?

    And what happens if you were to get disconnected? When you connect again could you rollback then? Or is everything committed?

Posting Permissions

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