#!/usr/bin/ruby require 'dbi' require 'odbc' dbh = DBI.connect('DBI:ODBC:prod', 'username', 'password') query = "select getdate()" row = dbh.select_one(query) puts "got a value of: " + row[0].to_s dbh.disconnect if dbh