Results 1 to 5 of 5

Thread: new transaction is not allowed error

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Somewhere in Vermont, USA - unless I'm not

    Default new transaction is not allowed error

    Hi -

    Today is my day for fun...

    VDF 17.0 SQL Express 2008R2 Mertech driver

    Error: New transaction is not allowed because there are other threads running in the session

    Getting the error on a few customer records - others are fine.

    I've googled it, but everyone syays it's because I'm running multiple threads. This app has been running fine - but Oplocks were turned off a few days ago. Might I still need them on?

    Any ideas appreciated -

    ETA: Oops - Oplocks were turned back ON - as they are no longer using the embedded DB.
    Last edited by Garret Mott; 11-Dec-2012 at 10:31 PM.

    All my life,I always wanted to be somebody. Now I see that I should have been more specific.

Posting Permissions

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