Connecting the "sequel" gem to MSSQL via ODBC

After you configured your ODBC describe in

• Fix [RubyODBC]Cannot allocate SQLHENV when connecting to MSSQL 2005 with Ruby 1.8.7. on Ubuntu 10.10
• and Connecting to MSSQL with Ruby on Ubuntu - lambie.org

you can connect with sequel Show archive.org snapshot :

require "rubygems"
require "sequel"
db = Sequel.odbc("MyODBCDatabaseName", :user => "my_user_name", :password => "my_password")
db["select top 5 name from user"].collect