From: "Israel T." <lists@...>
Date: 2012-09-12T05:46:48+09:00
Subject: ODBC Connection

Hi,

I have an ODBC (sql server 2005) connection but recently I needed to
reconfigure the odbc to connect to another sql server, not the local
one.

Since then rubi cannot establish connection thru ODBC. If I reconfigure
the ODBC connection back to the local server it works fine.

Any idea what went wrong?

Thanks

Code:

def fetch(query)
    ODBC::connect('odbc', 'user', 'password') do |dbc|
      stmt = dbc.run(query)
      result_set = []
      stmt.each do |row|
        result_set << row
      end
      result_set
    end
  end

-- 
Posted via http://www.ruby-forum.com/.