Sqlserver views instead of tables

Rails
1

Hello,
I have a legacy database in sqlserver 2005 that I am not allowed to
change. I have tried using a view, as I have read it works for
others, however I get an error.

I have this in my model:

class SheetEntryView < ActiveRecord::Base
set_table_name ‘Sheet_Entry_View’
set_primary_key ‘sheet_entry_KEY’
end

When I go to the console and try
->s=SheetEntryView
->SheetEntryView (Table doesn’t exist)

I think part of the problem can be traced to this message in my log,
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE =
‘BASE TABLE’

Is there something else I need to configure in activerecord to allow
it to work with sqlserver views?

Thanks,
Michael

2

I haven’t played around with it myself, but this might be a place to
start:

http://activewarehouse.rubyforge.org/rails_sql_views/