I have some admin and reporting scripts to run on a mssqlserver some of which return multiple results sets
I'm using ruby 1.92
previously with perl I'd used dbi which worked well.
But I failed to get any of the Ruby dbi libraries (DBI and RDBI) to work.
Finally I came across
tiny_tds
which has worked a treat even though I'm running the scripts on windows and it's unbelievably simple to use.