From: gregarican <greg.kujawa@...>
Date: 2010-01-22T02:05:10+09:00
Subject: Rails ADODB.Connection Error

I know this isn't exclusively a Rails list, so I apologize in advance.
Since this is the main list I work with I hope someone might have some
insight into a particularly nagging error message I have been getting.

The scenario is I have to move a working Rails setup to a new server.
So I installed Ruby/Rails/Apache/FastCGI on the new server as well as
a SQL Server instance. Then I copied over the Rails application
directory to the new box. Figuring that pointing Rails to the new SQL
Server instance would just involve modifying the database.yml file, I
changed the host name to the new SQL Server instance.

I can get the default Rails welcome page fine on the new server. But
when I try to launch my Rails app I get the error below. Any
suggestions about what specifically is the issue? Using IRB I can open
up the new SQL Server instance and query its Employee table fine on
the new server (which is what my Rails app is doing below).

DBI::DatabaseError in Employee#signIn

failed to create WIN32OLE object from `ADODB.Connection'
    HRESULT error code:0x8007007e
      The specified module could not be found.
app/controllers/employee_controller.rb:111:in `signIn'

Show framework trace

C:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `connect'
C:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:584:in `connect'
C:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:384:in `connect'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.10.0/lib/active_record/
connection_adapters/sqlserver_adapter.rb:49:in `sqlserver_connection'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.10.0/lib/active_record/
connection_adapters/abstract_adapter.rb:136:in `send'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.10.0/lib/active_record/
connection_adapters/abstract_adapter.rb:136:in `connection='
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.10.0/lib/active_record/
connection_adapters/abstract_adapter.rb:100:in `retrieve_connection'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.10.0/lib/active_record/
base.rb:235:in `connection'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.10.0/lib/active_record/
base.rb:366:in `find_by_sql'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.10.0/lib/active_record/
base.rb:334:in `find'
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.10.0/lib/active_record/
deprecated_finders.rb:37:in `find_all'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
base.rb:708:in `send'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
base.rb:708:in `perform_action_without_filters'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
filters.rb:294:in `perform_action_without_benchmark'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
benchmarking.rb:34:in `perform_action_without_rescue'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
benchmarking.rb:34:in `measure'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
benchmarking.rb:34:in `perform_action_without_rescue'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
rescue.rb:79:in `perform_action'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
base.rb:330:in `send'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
base.rb:330:in `process'
C:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.8.0/lib/action_controller/
base.rb:273:in `process'
C:/ruby/lib/ruby/gems/1.8/gems/rails-0.12.0/lib/dispatcher.rb:32:in
`dispatch'
C:/Program Files/Apache Group/Apache2/htdocs/po/public/dispatch.fcgi:
20
C:/Program Files/Apache Group/Apache2/htdocs/po/public/dispatch.fcgi:
18:in `each_cgi'
C:/ruby/lib/ruby/site_ruby/1.8/fcgi.rb:597:in `each'
C:/ruby/lib/ruby/site_ruby/1.8/fcgi.rb:597:in `each_cgi'
C:/Program Files/Apache Group/Apache2/htdocs/po/public/dispatch.fcgi:
18