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:/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'
I haven't found anything online that was a substantial help