I’m trying to find a way to use ruby to connect to a MS SQL database.
I need it to be as simple I can to run on both windows and linux
systems. So if they require different things to make them work, I want
to have the smallest difference in code that I can.
I also need to support stored procedures returning multiple record sets
so something like .NextRecordSet needs to be supported.
I can get a connection using: require ‘dbi’ and ODBC BUT ODBC doesn’t
appear to support multiple record sets.
I’ve been attempting to get ADO to fall in line but, my understanding,
is that it’s not very happy with linux.
So in summary:
-MSSQL DB connection
-Must be usable across Linux and Windows with minimal changes
-Must allow for multiple record sets
Does anyone have suggestions for me?
Thanks in advance.