DBI: connect succeeds in IRB, fails in Rails

rubyonrails-talk
1

require 'dbi' # 0.4.2 dbh = DBI.connect('DBI:ODBC:PACS', 'username', 'password')

This works in IRB; in Rails it fails (taken from Rails console): DBI::InterfaceError: Unable to load driver 'ODBC' (underlying error: uninitialized constant DBI::DBD::ODBC)         from C:/scripts/Rads/vendor/gems/dbi-0.4.2/lib/dbi.rb:300:in `load_driver'         from c:/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'         from C:/scripts/Rads/vendor/gems/dbi-0.4.2/lib/dbi.rb:242:in `load_driver'         from C:/scripts/Rads/vendor/gems/dbi-0.4.2/lib/dbi.rb:160:in `_get_full_driver'         from C:/scripts/Rads/vendor/gems/dbi-0.4.2/lib/dbi.rb:145:in `connect'         from (irb):2

I haven't found anything online that was a substantial help :confused:

2

Oh -- Ruby 1.8.7, and I can connect by writing a small script and launching it with Ruby (same version of Ruby that Rails uses).