I am looking to populate dynamic dropdowns using ruby to run select queries on MSSQL servers.
Do any of you know how to get somethig like this working?
This probably isn’t the best path, but i looked into getting tiny_tds to work which appears to be an option for getting ruby to talk to MSSQL databases.
I installed freetds (yum install freetds) and tried to install tiny_tds (gem install tiny_tds), but it throws an error when trying to do the install.
I posted my error on this github page (https://github.com/github/pages-gem/issues/133) and they said:
It looks like you’re using a custom version of Ruby installed to /opt/rh/rh-ruby22/root/usr. Installing ruby-devel won’t install the headers into this location, but into /usr/share/include/ruby.h instead. You will need to install the headers for the binary located at /opt/rh/rh-ruby22/root/usr/bin/ruby
(ruby-devel is a pre req for tiny_tds)
Basically, I don’t know what the best way to get this working. Maybe it is a fools errand?