Activerecord and mssql server


#1

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