Forum: Ruby on Rails activerecord and mssql server

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Jay D. (Guest)
on 2006-04-19 01: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
    OLE error code:80004005 in Microsoft OLE DB
Provider for SQL Server
      Cannot create new connection because in manual
or distributed transaction
    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
This topic is locked and can not be replied to.