# Activerecord-sqlserver adapter broken or worse **URL:** \ **Category:** Rails\ **Created:** [June 30, 2008, 10:45pm UTC](https://www.ruby-forum.com/t/activerecord-sqlserver-adapter-broken-or-worse/141833 "2008-06-30T22:45:45Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![hatless](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/848f3c/32.png) [@hatless](https://www.ruby-forum.com/u/hatless)\ **Post date:** [June 30, 2008, 10:45pm UTC](https://www.ruby-forum.com/t/activerecord-sqlserver-adapter-broken-or-worse/141833/1 "2008-06-30T22:45:45Z")
The activerecord-sqlserver-adapter gem is still sort of available via [gems.rubyonrails.org](http://gems.rubyonrails.org), but it will not install on machines that have Rails 2.1 (or its version of ActiveSupport) installed. This has been confirmed with versions of rubygems through 1.2. This seems to indicate that Rails is no longer tested against the MSSQL adapter and that the adapter is also no longer tested against Rails since the move of the Rails core to Git. Is MSSQL still considered a support target for RoR or has it been deprecated entirely? For all its known bugs especially against SQL Server 2005, the MSSQL adapter at least installed properly and still seemed to receive patches now and then into the Rails 2.0.x era. Are adapters for any of the commercial databases still actively supported, or are mysql, postgres and sqlite the only databases any of us should be using with AR in the future? Was the removal from the core intended as a decoupling or a deprecation? Thanks. ---
**Author:** ![hatless](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/848f3c/32.png) [@hatless](https://www.ruby-forum.com/u/hatless)\ **Post date:** [June 30, 2008, 11:08pm UTC](https://www.ruby-forum.com/t/activerecord-sqlserver-adapter-broken-or-worse/141833/2 "2008-06-30T23:08:58Z")
On 30 Jun 2008, at 21:45, Steve K. wrote: > support target for RoR or has it been deprecated entirely? For all its > known bugs especially against SQL Server 2005, the MSSQL adapter at > least installed properly and still seemed to receive patches now and > then into the Rails 2.0.x era. The rails unit tests are usually run against mysql, postgres, sqlite. Apart from anything else most contributors can’t run the tests against those databases. A while back I made some changes to rails’ test which required some database specific changes. I handled postgres, mysql, sqlite myself since I have easy access to them. I was told not to worry about the others, that it was up to their maintainers to keep the tests passing. > Are adapters for any of the commercial databases still actively > supported, or are mysql, postgres and sqlite the only databases any of > us should be using with AR in the future? Was the removal from the > core > intended as a decoupling or a deprecation? I don’t believe rails-core worries about them much (hence the decoupling). I’ve no idea who maintains the mssql adapter, but I suggest you voice your concerns to them. Fred ---
**Author:** ![hatless](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/848f3c/32.png) [@hatless](https://www.ruby-forum.com/u/hatless)\ **Post date:** [July 1, 2008, 5:19am UTC](https://www.ruby-forum.com/t/activerecord-sqlserver-adapter-broken-or-worse/141833/3 "2008-07-01T05:19:52Z")
Interesting. I just did this install without issue. gem -v 1.1.1 rails -v Rails 2.1.0 sudo gem install activerecord-sqlserver-adapter --source= [http://gems.rubyonrails.org](http://gems.rubyonrails.org) Updating metadata for 13 gems from [http://gems.rubyonrails.org/](http://gems.rubyonrails.org/) … complete Updating metadata for 13 gems from [http://gems.rubyonrails.org/](http://gems.rubyonrails.org/) … complete Successfully installed activerecord-sqlserver-adapter-1.0.0.9250 1 gem installed We use sqlserver adapter daily, though admittedly we use it against sqlserver 2000. No issues in the last 2 years. On Mon, Jun 30, 2008 at 3:45 PM, Steve K. \<