Ruby 1.9, Rails 2.3.2, and MSSQL issue

rubyonrails-talk
1

I am having a strange issue. I have upgraded to ruby 1.9.1 to do some testing on one of my machines. My app accesses a MSSQL database to pull in some information. Everything worked fine with ruby 1.8.6, but now if I try to navigate to a page that accesses that database I get this error:

DBI::InterfaceError in PagesController#company Unable to load driver 'ODBC' (underlying error: uninitialized constant DBI::DBD::ODBC)

I'm using activerecord-sqlserver-adapter (1.0.0.9250), dbd-odbc (0.2.4), and dbi (0.4.1)

2

I would say not all gems are mature for 191! Am I wrong?

3

You are right. The reason I posted this was because it was working using script/console, which would have meant the gems were all working with 1.9.1, but not when navigating to the page on the site. Then I realized that I was still running irb under ruby 1.8.6. Once I updated that to 1.9.1 it quit working. So yes it appears to be the gems are incompatible with 1.9.1.