dbd-odbc gem not found

It's not the gem that's missing. It's the Ruby ODBC bindings which you need from here: ODBC Binding for Ruby.

Once the correct Ruby bindings are installed, you can require 'odbc' with no dependencies.

HTH, Dave