# Help to install ROR with MS-SQL

**URL:** <https://www.ruby-forum.com/t/help-to-install-ror-with-ms-sql/196916>\
**Category:** Ruby\
**Created:** [March 16, 2009, 12:55pm UTC](https://www.ruby-forum.com/t/help-to-install-ror-with-ms-sql/196916 "2009-03-16T12:55:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sankarkumar](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/90db22/32.png) [@sankarkumar](https://www.ruby-forum.com/u/sankarkumar)\
**Post date:** [March 16, 2009, 12:55pm UTC](https://www.ruby-forum.com/t/help-to-install-ror-with-ms-sql/196916/1 "2009-03-16T12:55:05Z")

</div>

Hi,

I have already installed ROR with sqlite & mysql .  
& now i need to have ROR with MSSQL.  
Here is my existing ROR details ,  
actionmailer (2.2.2)  
actionpack (2.2.2)  
activerecord (2.2.2)  
activeresource (2.2.2)  
activesupport (2.2.2)  
columnize (0.3.0)  
linecache (0.43)  
mysql (2.7)  
rails (2.2.2)  
rake (0.8.3)  
ruby-debug (0.10.3)  
ruby-debug-base (0.10.3)  
sqlite3-ruby (1.2.4)

Can you please somebody help me to install ror with MS-SQL ?

Thanks,  
Sankar.

---

<div class="post-metadata">

**Author:** ![sankarkumar](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/90db22/32.png) [@sankarkumar](https://www.ruby-forum.com/u/sankarkumar)\
**Post date:** [March 17, 2009, 8:23am UTC](https://www.ruby-forum.com/t/help-to-install-ror-with-ms-sql/196916/2 "2009-03-17T08:23:03Z")

</div>

Sankar K. wrote:

> Hi,
> 
> I have already installed ROR with sqlite & mysql .  
> & now i need to have ROR with MSSQL.

You need to install odbc support on linux. This is my short rundown on  
Ubuntu.

- install dbi and ruby odbc (synaptic)
- install unixodbc apt get install unix-odbc
- install freeTDS driver (synaptic)
- configuration files are in /etc/odbc.ini /etc/odbcinst.ini

You will also need ar support for mssql:  
gem install activerecord-sqlserver-adapter  
–source=http://gems.rubyonrails.org

by  
TheR