Connection with MS SQL Server

[Jens Riedel]

Hi,

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!

Thanx
Jens

 

[KlausG]

Hallo Jens,

You may use ruby-odbc (http://www.ch-werner.de/rubyodbc/)
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.

Klaus

 

[David Harkness]

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

http://rubykata.wordpress.com/connecting-to-sql-server-from-unix-with-ruby/