simple remote ODBC database connection with ruby

Question

I am attempting to make a simple connection to a remote database. I can not seem to get it to work.

remote_db = DBI.connect('DBI:ODBC:remote-host','user','password')
remote_db.table { |table| pp table }

Any help would be greatly appreciated.