JGaudette
10/25/2010 - 11:57 AM

odbc_ruby_example.rb

#!/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