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'

activerecord-sqlserver-adapter
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: http://www.freetds.org/
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.