# Setting up Rails with MS SQL

**URL:** <https://www.ruby-forum.com/t/setting-up-rails-with-ms-sql/169586>\
**Category:** Deployment\
**Created:** [June 5, 2009, 5:23pm UTC](https://www.ruby-forum.com/t/setting-up-rails-with-ms-sql/169586 "2009-06-05T17:23:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nnexican](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/e274bd/32.png) [@nnexican](https://www.ruby-forum.com/u/nnexican)\
**Post date:** [June 5, 2009, 5:23pm UTC](https://www.ruby-forum.com/t/setting-up-rails-with-ms-sql/169586/1 "2009-06-05T17:23:14Z")

</div>

Hello everyone. I am trying to get Rails working with MS SQL. I have  
updated database.yml in my application, intalled the  
activerecord-sqlserver-adapter gem as well as the deprecated gem. I have  
also downloaded ADO.rb into the appropiate folder (Ruby  
path\lib\site\_ruby\1.8\dbd\ado) However, when I run “rake db:migrate” I  
get the following error:

rake aborted!  
Unable to load driver ‘ADO’ (underlying error: uninitialized constant  
DBI::DBD::ADO)

(See full trace by running task with --trace)

Thanks to everyone!

---

<div class="post-metadata">

**Author:** ![nnexican](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/e274bd/32.png) [@nnexican](https://www.ruby-forum.com/u/nnexican)\
**Post date:** [September 10, 2009, 8:57pm UTC](https://www.ruby-forum.com/t/setting-up-rails-with-ms-sql/169586/2 "2009-09-10T20:57:16Z")

</div>

I am having exactly the same problem. I was able to create an ODBC  
connection on the server and connect that way, but that’s not ideal.