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@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.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouprubyonrails-talk @
categoriesrubyonrails
postedAug 1, '13 at 6:13a
activeAug 1, '13 at 6:13a
posts1
users1
websiterubyonrails.org
irc#RubyOnRails

1 user in discussion

Edgar Gonzalez: 1 post

People

Translate

site design / logo © 2021 Grokbase