Firebird, fireruby

rubyonrails-talk
1

Hi Guys

I am pretty new to Ruby. One of our client is using Firebird as his backend database. I have to create a script which will connect to his database, fetch some data and update few tables in MS-SQL database.

Now problem is: i have installed FireRuby, got databaes, changed my database.yml file.

I am trying to display all the users in Members table. but i am getting following error:

ActiveRecord::AdapterNotFound in UsersController#index

The Firebird adapter requires FireRuby version 0.4.0 or greater; you appear to be running an older version -- please update FireRuby (gem install fireruby).

RAILS_ROOT: C:/rails/cprc/config/.. Application Trace | Framework Trace | Full Trace

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/firebird_adapter.rb:29:in `firebird_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/abstract/connection_specification.rb:262:in `send' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/abstract/connection_specification.rb:262:in `connection_without_query_cache=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ query_cache.rb:54:in `connection=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/abstract/connection_specification.rb:230:in `retrieve_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/abstract/connection_specification.rb:78:in `connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ base.rb:1139:in `add_limit!' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ base.rb:1101:in `construct_finder_sql' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ base.rb:997:in `find_every' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ base.rb:418:in `find' #{RAILS_ROOT}/app/controllers/users_controller.rb:13:in `index'

Please advice.

thanks

Ajit Singh

2

Ajit schrieb:

Hi Guys

I am pretty new to Ruby. One of our client is using Firebird as his backend database. I have to create a script which will connect to his database, fetch some data and update few tables in MS-SQL database.

Now problem is: i have installed FireRuby, got databaes, changed my database.yml file.

I am trying to display all the users in Members table. but i am getting following error:

ActiveRecord::AdapterNotFound in UsersController#index

The Firebird adapter requires FireRuby version 0.4.0 or greater; you appear to be running an older version -- please update FireRuby (gem install fireruby).

RAILS_ROOT: C:/rails/cprc/config/.. Application Trace | Framework Trace | Full Trace

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/firebird_adapter.rb:29:in `firebird_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/abstract/connection_specification.rb:262:in `send' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/abstract/connection_specification.rb:262:in `connection_without_query_cache=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ query_cache.rb:54:in `connection=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/abstract/connection_specification.rb:230:in `retrieve_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ connection_adapters/abstract/connection_specification.rb:78:in `connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ base.rb:1139:in `add_limit!' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ base.rb:1101:in `construct_finder_sql' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ base.rb:997:in `find_every' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ base.rb:418:in `find' #{RAILS_ROOT}/app/controllers/users_controller.rb:13:in `index'

Please advice.

thanks

Ajit Singh

>

I have the unfortunate experience of working with Firebird/FireRuby

what version of FireRuby do you have installed? My current win32 version is 0.4.1

try a "gem query list -n fireruby" from cmd

andy

3

its the latest 0.4.1

but i have figured out the solution., I updated my environment.rb with FIRERUBY_GEM_VERSION = '0.4.1' unless defined? FIRERUBY_GEM_VERSION and it worked

thanks

Ajit