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

Martin Straub

Say thanks2

Last edit

2012-03-28

Keywords

ruby, gem, SQL, Server

License

Source code in this card is licensed under the MIT License.

Posted by Martin Straub to makandra dev (2012-03-23 09:40)