MS SQL Server with Ruby

ActiveRecord::Base.sqlserver_connection({"mode"=>"ODBC", "adapter"=>"sqlserver", "dsn"=>"DRIVER=/usr/local/lib/libtdsodbc.so;TDS_Version=8.0;SERVER=173.15.160.129;DATABASE=TMWSuite_LIVE;Port=1433;uid=tracell;pwd=XXXX;"})

Config:
  adapter: sqlserver
  mode: ODBC
  dsn: 'DRIVER=/usr/lib/libtdsodbc.so;TDS_Version=8.0;SERVER=XXXX;DATABASE=XXXX;Port=1433;uid=XXXX;pwd=XXXX;'

Linux:

sudo gem install dbd-odbc --no-ri --no-rdoc
sudo gem install dbi --no-ri --no-rdoc
sudo apt-get install libdbd-odbc-ruby1.8
sudo apt-get install freetds-dev

Mac:
sudo gem install dbd-odbc --no-ri --no-rdoc
sudo gem install dbi --no-ri --no-rdoc
wget http://ch-werner.de/rubyodbc/ruby-odbc-0.9996.tar.gz
tar -xvzpf ruby-odbc-0.9996.tar.gz
cd ruby-odbc-0.9996
ruby extconf.rb
make
sudo make install
sudo port install freetds