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: > 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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---