What is the best option for connecting Rails 4.2.5 to MS SQL Server 2008? -


does know of best solution connect old 2008 sql server? yeah, know it’s old. i’ve been looking sql-server-adapter gem, targeting 4.1.x it’s not quite there. running rails 4.2.6 , ruby 2.2.5.

i've tried using activerecord-sqlserver-adapter 4.1.2 thought best option. can connect fine, when attempting first record, or record matter, doesn't return active record object.

i've tried loop it, says can't [] of nil class. if yaml::dump(theobject.first) spits out string \n breaks record.

i feel there's missing, though i've followed tutorials , using bare minimum necessary connect.

it's first time we've tried connecting mssql rails it's rather new. nothing connecting mongo or postgres or mysql. lol.

seems stackoverflow consensus "don't". there 2 similar questions kind of give answer, both it's not easy or straightforward.
answer seems helpful: https://stackoverflow.com/a/5176511/275780
references question: rails & mssql 2008 - hit barriers? advocates jruby , says it's pain.
answer: https://stackoverflow.com/a/13518152/275780 seems helpful if you're going go it.