MSSQL error - 80004005 & Rails


#1

hey there folks, i have a bit of a sitch here and i would love some
help/input on it.

i’ve inherited a horrible asp/mssql app that i’m re-writting using
rails, but unfortunately i have to keep the asp version up and running.
in order to do so i’ve had to write some admin functions, which i’ve
done in rails. because the mssql schema wasn’t written very well i’ve
had to override the table and primary keys for active record. my
‘user.rb’ file looks like this.

class User < ActiveRecord::Base
set_table_name “users”
set_primary_key “user_id”
end

i’m not having any problems reading from the database (sql server 2000),
but when i try to update something i get the following error:

ActiveRecord::StatementInvalid: DBI::DatabaseError: 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
Exception occurred.: SELECT @@ROWCOUNT AS AffectedRows: UPDATE
users SET [sb_username] = ‘’, [hl_perclick_replenish] = NULL, [fname] =
‘Mark’, [ccExpYear] = NULL, [nameoncard] = ‘’, [hl_perclick_method] =
NULL, [ccType] = NULL, [hl_perclick_charged_date] = NULL,
[where_heard_code] = NULL, [deleted] = 0, [cookie_expires] = NULL,
[bill_state] = NULL, [userTyp] = 1, [cookie_id] = NULL, [phone] = NULL,
[bill_city] = ‘’, [referer] = ‘http://www.foo.com/’, [rank_elig] = NULL,
[hl_perclick_budget] = NULL, [address2] = ‘’, [browser] = ‘Mozilla/5.0
(Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.0.1) Gecko/20060111
Firefox/1.5.0.1’, [bio] = NULL, [login_name] = ‘foo’, [lname] = ‘bar’,
[hl_perclick_charged] = NULL, [hl_active] = 0, [zip] = ‘’, [address1] =
‘’, [modDT] = NULL, [country] = NULL, [province] = ‘’, [password] =
‘password’, [ccNum] = ‘’, [hearabout] = ‘Foo B.’, [last_logon] = NULL,
[site] = ‘hk’, [creatDT] = ‘2006-03-08 11:48:09’, [ccExpMonth] = NULL,
[email] = ‘removed_email_address@domain.invalid’ WHERE user_id = 10560.0

does anybody have any ideas how i can fix this?? please please please
help. thanks.


#2

Got the same problem.

Does anyone have a solution for this?