From: "Choi, Junegunn" <jg@...>
Date: 2009-02-22T18:16:59+09:00
Subject: Re: MSSQL DB connection, multiplatform, NextRecordSet

2009/2/21 Joseph Still <daitai.raifu@gmail.com>:
>
> So in summary:
> -MSSQL DB connection
> -Must be usable across Linux and Windows with minimal changes
> -Must allow for multiple record sets
>

Hi, If it's ok to use JRuby, you can try JDBC with JRuby. I have no
experience in MSSQL and ADO, but i'm sure MSSQL provides JDBC driver
and JDBC is inherently compatible across different platforms. And if I
understood your point correctly, it supports multiple record sets as
well. The following JRuby code works with my PostgreSQL database.

stmt.execute 'select * from test_a; select * from test_b'
rset = stmt.get_result_set
while rset.next
    puts rset.get_long(1)
end

stmt.get_more_results
rset = stmt.get_result_set
while rset.next
    puts rset.get_long(1)
end


-- 
junegunn.