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.
Garret
Time for an oldie but goodie:
"If it ain't broke, you're not trying." - Red Green