HanShi,

I added another ADO Connection inside the App and tweaked the use of Command objects as well. It appears to have fixed the error! You got me to...

Please review my earlier reply to another trying to assist. I posted another method that works, (Debug session originally works and I just posted a call from within SQL...

It uses the same connection from ADO. The Transaction is part of the T-SQL SP, not wrapped in the ADO call. I indicated in the original post that...