search

rails-sqlserver / tiny_tds

TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.
Other
607 stars 189 forks source link

TinyTDS support for SQL Server 2019 #449

Closed sithara closed 4 years ago

sithara commented 4 years ago

Does tinytds -v 0.7.0 running on ruby 1.9.3 support sql server -v 2019 ? 0.7.0v worked for me till sql server -v2016 but not beyond that. My activerecord-sqlserver-adapter version is 3.2.16

aharpervc commented 4 years ago

Probably not, if it didn't work with 2016. But it'd be interesting to know what happened when you tried. Also, 0.7.0 is quite old and support for ruby 1.9.3 ended 5 years ago this February

sithara commented 4 years ago

image It worked for 2016 but not beyond that. Is there a workaround ?

sithara commented 4 years ago

Hi @aharpervc

I tried upgrading the activerecord-sqlserver-adapter version to 3.2.18 and the app now supports sql version 2017.

image

Is there a patch or workaround for sql server v2019 support?

KDGundermann commented 4 years ago

you error is from the activerecord_sqlserver_adapter gem, TinyTDS has nothing to do with it.. so, you are still using Rails 3 ?? Why not update to Rails 5 ?

You may clone the project activerecord_sqlserver_adapter, change the line sqlserver_adapter.rb#L184 run your tests and see if you are happy ;-)

sithara commented 4 years ago

Thank you @KDGundermann for helping me on this :)