"ERROR: sql.h not found" when installing ruby-odbc gem on Ubuntu

Question

Attempting to install ruby-odbc gem on Debian/Ubuntu results in the following error;

"ERROR: sql.h not found"

Answer 1

This happens on OSX too so brew to the rescue:

brew install unixodbc

Answer 2

Install the unixodbc-dev package, then try the gem install again

sudo apt-get install unixodbc-dev
gem install ruby-odbc