8i7yfa
Last Updated: February 25, 2016
·
1.03K
· dpaluy
3129de6b479cc965513311f1ddcc268a

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.

Say Thanks
Respond