Is there a ruby library that can connect to the following connection string

Ruby
1

Is the a ruby library that’s able to connect to the following kinds of
connection strings without needing to parse it. There is something in
C#, but I haven’t be able to find something in Ruby.

E.g.

Data
Source=myserver\SQL2008SERVER;Integrated%20Security=True;Enlist=False;database=mydatabase"

and

Server=myserver;UID=user;PWD=password;Enlist=false;Connection%20Reset=true;database=mydatabase"

I have tried using sequel and tinyds. Could someone help, please?

2

I use Sequel to connect to and query SQL Server 2008 databases, using
the ADO adapter. For example:

require ‘sequel’

DB = Sequel.ado(:conn_string=>‘Provider=SQLOLEDB;Data
Source=<YOUR_SERVER>,;User
ID=<YOUR_USER_ID>;Password=YOUR_PASSWORD>;Initial
Catalog=<YOUR_DATABASE_NAME>;’)

dataset = DB.fetch(“SELECT * FROM ___;”).all

David