i am trying to create some JSON services for a legacy database i have in firebird.
I have installed firebird adapter and it seems it is working but is always throwing an error: Fb::Error: Undefined name Dynamic SQL Error SQL error code = -204 Table unknown MSFCLIENTES At line 1, column 45 : SELECT "MSFCLIENTES".* FROM "MSFCLIENTES" ORDER BY "MSFCLIENTES"."ID" ASC ROWS 1 the log shows like if it is quering the wrong table "RDB$DATABASE" (one of the system tables), so if i change the table name to that table it works but it isnt the table i need... here is my model class Client < ActiveRecord::Base establish_connection( :adapter => "fb", :database => "localhost:/var/databases/MSFBASE.Ib", #:database => "sales", :username => "SYSDBA", :password => "masterkey", :charset => "NONE") self.table_name = "MSFCLIENTES" #self.primary_key = 'RDB$RELATION_ID' #self.table_name = "RDB$DATABASE" #self.primary_key = 'RDB$RELATION_ID' # self.table_name = 'employee' end -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/2dd056196c35739f23bc433adebc76cd%40ruby-forum.com. For more options, visit https://groups.google.com/groups/opt_out.