Connection with MS SQL Server


I’m looking for a library which enables me to execute SQL statements on
a MS SQL database server. The libs I found until now on the Net seemed
to allow only SELECT statements, I need to to the following operations:

create table

select count…

drop table

rename table

Any hints appreciated very much!


Hallo Jens,

You may use ruby-odbc (
On Windows or on Linux together with FreeTDS
You may also look at activerecord-sqlserver-adapter gem and their
website for some hints for installing it.


Here’s a wiki I wrote a long time ago on setting up ruby on unix to with
with sql server

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs