# Please explain transactions within sqlserveradapter.rb?

**URL:** <https://www.ruby-forum.com/t/please-explain-transactions-within-sqlserveradapter-rb/99768>\
**Category:** Rails\
**Created:** [February 1, 2006, 6:27pm UTC](https://www.ruby-forum.com/t/please-explain-transactions-within-sqlserveradapter-rb/99768 "2006-02-01T18:27:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![churp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/f14d63/32.png) [@churp](https://www.ruby-forum.com/u/churp)\
**Post date:** [February 1, 2006, 6:27pm UTC](https://www.ruby-forum.com/t/please-explain-transactions-within-sqlserveradapter-rb/99768/1 "2006-02-01T18:27:45Z")

</div>

Hello everyone,

I am needing to resolve an error on sqlserveradapter revolving around a  
trigger on a table. When the AR object is saved, AR throws

Cannot create new connection because in manual or distributed  
transaction  
mode.

at

from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract\_adapter.rb:88:in  
`log’

In order to resolve this, I need to understand how the  
connection/transaction is setup in AR. This may also require my  
learning of  
the DBI::ADO functionality as well.

Who will step up to the plate and begin a conversation with me on this?

## Thank you!