Rails + Firebird (legacy database)


#1

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