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+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
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.