tiny_tds gem installation issue on Rails 5

Question

I have tried to install gem tiny_tds on Rails 5, but not able to install. I have googled it and tried all the solution. But there is no solution. Can you please suggest me to install it. Below are the solutions I have tried,

Rails 4: Error when installing tiny_tds gem?

sudo apt-get install freetds-dev

Answer 1

tiny_tds gem can be easily installed from terminal using following command:

$ gem install tiny_tds

If any other issue you are facing with tiny_tds gem you can refer the documentation of gem: https://github.com/rails-sqlserver/tiny_tds

Answer 2

Debian 10
Rails: 5.2
Ruby 2.5

How to Install FreeTDS:

• source: https://www.microsoft.com/en-us/sql-server/developer-get-started/ruby/ubuntu/

Use the Terminal with Root or Sudo permissions to run the following commands:

wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.00.27.tar.gz
tar -xzf freetds-1.00.27.tar.gz
cd freetds-1.00.27
./configure --prefix=/usr/local --with-tdsver=7.3
make
sudo make install
cd ..
gem install tiny_tds

This should get you started.

Answer 3

Make sure you have freetds library installed in case of MacOS

brew install freetds