Last Updated: February 25, 2016
· dpaluy

Working with SQL Server with Ruby On Rails and Ubuntu

To work with SQL Server in Rails you need the following gems:

gem 'activerecord-sqlserver-adapter'
gem 'tini_tds'


Before installing those gems, you need FreeTDS

If you install the free_tds via sudo apt-get install freetds-dev, your connection probably won't work. You will need a version 0.91

Do the following:

  1. Download stable release:
  2. Extract it: tar xvzf freetds-stable.tgz
  3. cd freetds-0.91
  4. ./configure
  5. make
  6. sudo make install
  7. Verify your FreeTDS: $ tsql -C

Now you can install your gems.