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
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
Do you have odbc resource defined in odbc connections.