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

Israel T. wrote in post #1075534:

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

Do you have odbc resource defined in odbc connections.

I use tiny_tds https://github.com/rails-sqlserver/tiny_tds since it
doesn’t require any other local settings. And it works without problems
on Linux and Windows.

by
TheR

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs