Hello all, I am revisiting this issue with Active Record. A MS Sql table with a trigger causes "Cannot create new connection because in manual or distributed transaction mode." during unit test at abstract_adapter#log. This has something to do with this MSDN knowledgebase item : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_471q.aspwhich says : " @@TRANCOUNT is incremented by one when entering a trigger, even when in autocommit mode. (The system treats a trigger as an implied nested transaction.) " I don''t understand enough about DBI:ADO to divine what the issue is here. What I can guess from the error below is that the DBI:ADO connection cannot handle an implicit transaction, but I don''t know why, I think transaction handling is a basic requirement of implementation for the ADO driver. Does anyone have further information on this or some idea of where to look next for assistance ? BTW: Was one of you working on a pure-ruby database driver for SQL Server ? Thanks one and all. Peter Fitzgibbons Follow this recipe to example error : 1. Setup any sql server database and run the attached .sql script 2 create a rails app, connect database.yml to your db 3. copy attached triggertests.yml into the rails .\fixtures. 4. ruby script/generate model triggertest 5. ruby test\unit\triggertest_test.rb 6. You should get this : (attached in trigger_test_fail.out) Loaded suite C:\ruby\dev\pm\test\unit\triggertest_test Started E Finished in 0.297 seconds. 1) Error: test_truth(TriggertestTest): ActiveRecord::StatementInvalid: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 7. run disable trigger script in SQL Query Analyzer alter table [dbo].[triggertests] disable trigger [TR_triggertests] GO 8. Rerun test ruby test\unit\triggertest_test.rb Loaded suite C:\ruby\dev\pm\test\unit\triggertest_test Started . Finished in 1.094 seconds. 1 tests, 1 assertions, 0 failures, 0 errors Program exited with code 0 _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails