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:
- Download stable release: http://www.freetds.org/
- Extract it:
tar xvzf freetds-stable.tgz
sudo make install
- Verify your FreeTDS:
$ tsql -C
Now you can install your gems.