I have followed the cookbook on
but am having problems with the rails part. I can connect to the
database using sqsh so I think all the freetds plumbing is good. When
I try to connect to the db with a rake db:migrate or just using script/
console I get this error:
DBI::InterfaceError: Unable to load driver ‘ODBC’
load_driver' from /usr/lib/ruby/1.8/monitor.rb:242:insynchronize’
load_driver' from /usr/lib/ruby/gems/1.8/gems/dbi-0.4.0/lib/dbi.rb:154:in_get_full_driver’
connect' from /usr/lib/ruby/gems/1.8/gems/activerecord-sqlserver- adapter-126.96.36.19950/lib/active_record/connection_adapters/ sqlserver_adapter.rb:47:insqlserver_connection’
send' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/abstract/connection_pool.rb:223:innew_connection’
So I looked into dbi.rb and I see where it throws the exception. It
can’t seem to get the Driver called ODBC. I do have dbd-odbc-0.2.4
installed. Seems like the dbi part is not connecting to the odbc
Rails is running on ubuntu 8.1.
Any pointers would be very welcome.
*** LOCAL GEMS ***