Connection with MS SQL Server

Ruby
1

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

2

Hallo Jens,

You may use ruby-odbc (ODBC Binding for Ruby)
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

3

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