From: Joseph Still <daitai.raifu@...>
Date: 2009-02-23T23:24:50+09:00
Subject: Re: MSSQL DB connection, multiplatform, NextRecordSet

> 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

I'm not familiar with JRuby.
I'm fairly open to options so I'll take a look at it.
Just that it supports multiple record sets is a step forward.

Thanks for the heads up.
-- 
Posted via http://www.ruby-forum.com/.