# Cannot find sqlserver adaptor for ActiveRecord

**URL:** <https://www.ruby-forum.com/t/cannot-find-sqlserver-adaptor-for-activerecord/139290>\
**Category:** Rails\
**Created:** [June 2, 2008, 5:20pm UTC](https://www.ruby-forum.com/t/cannot-find-sqlserver-adaptor-for-activerecord/139290 "2008-06-02T17:20:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![harleym](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/e495f1/32.png) [@harleym](https://www.ruby-forum.com/u/harleym)\
**Post date:** [June 2, 2008, 5:20pm UTC](https://www.ruby-forum.com/t/cannot-find-sqlserver-adaptor-for-activerecord/139290/1 "2008-06-02T17:20:29Z")

</div>

I have been trying to find the adtiverecord adaptor for MS SQL server  
and attempted to install with the command found on the  
[http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer](http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer)  
wiki page:

gem install activerecord-sqlserver-adapter --source=http://  
[gems.rubyonrails.org](http://gems.rubyonrails.org)

I then got the error message:

ERROR: could not find activerecord-sqlserver-adapter locally or in  
a repository

Does anyone know where the sqlserver adaptor has gone for activerecord  
2.0.2?

Harley Mackenzie

---

<div class="post-metadata">

**Author:** ![harleym](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/e495f1/32.png) [@harleym](https://www.ruby-forum.com/u/harleym)\
**Post date:** [June 2, 2008, 5:36pm UTC](https://www.ruby-forum.com/t/cannot-find-sqlserver-adaptor-for-activerecord/139290/2 "2008-06-02T17:36:32Z")

</div>

What about using the activerecord-odbc-adapter instead?

best.  
mike

---

<div class="post-metadata">

**Author:** ![harleym](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/e495f1/32.png) [@harleym](https://www.ruby-forum.com/u/harleym)\
**Post date:** [June 2, 2008, 6:02pm UTC](https://www.ruby-forum.com/t/cannot-find-sqlserver-adaptor-for-activerecord/139290/3 "2008-06-02T18:02:01Z")

</div>

[http://groups.google.com/group/rails-sqlserver-adapter/](http://groups.google.com/group/rails-sqlserver-adapter/)

---

<div class="post-metadata">

**Author:** ![harleym](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/e495f1/32.png) [@harleym](https://www.ruby-forum.com/u/harleym)\
**Post date:** [June 3, 2008, 6:06pm UTC](https://www.ruby-forum.com/t/cannot-find-sqlserver-adaptor-for-activerecord/139290/4 "2008-06-03T18:06:54Z")

</div>

Mike,

Any examples on how to do this?

All the documentation I’ve seen has the sqlserver adapter using odbc  
as the mode.

Thanks,

Andrew

---

<div class="post-metadata">

**Author:** ![harleym](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/e495f1/32.png) [@harleym](https://www.ruby-forum.com/u/harleym)\
**Post date:** [June 3, 2008, 6:54pm UTC](https://www.ruby-forum.com/t/cannot-find-sqlserver-adaptor-for-activerecord/139290/5 "2008-06-03T18:54:58Z")

</div>

Here’s the project’s home page: [http://odbc-rails.rubyforge.org/](http://odbc-rails.rubyforge.org/)

(disclaimer: I have never used this gem. I’ve never needed to interact  
with SQL Server.)

best.  
mike