Forum: Ruby on Rails activerecord and mssql server

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
8de6094e9df399c87da91be9ddf963e5?d=identicon&s=25 Jay Donnell (bloc)
on 2006-04-18 23:47
(Received via mailing list)
I'm trying to use activerecord outside of rails with a
legacy mssql database. Reading from the db works, but
when I try to save a new object (i.e. insert) I get
the following error.

DatabaseError: Execute
(ActiveRecord::StatementInvalid)
    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
      Exception occurred.: SELECT @@IDENTITY AS Ident:


Anyone have any ideas on this? mssql server is not my forte.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
This topic is locked and can not be replied to.