sqlserver views instead of tables

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

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

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

mfairchi wrote: