I have an application that connects to a remote SQL Server database using DBI/ODBC. If I run the application via the Rails console, I am able to retrieve data and work with the database just fine. If, however I try to access it via the Web application itself, I get the following error:
DBI::DatabaseError (S1000 (0) [unixODBC][FreeTDS][SQL Server]Unable to connect to data source): /usr/lib/site_ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect' /usr/lib/site_ruby/1.8/dbi.rb:424:in `connect' /usr/lib/site_ruby/1.8/dbi.rb:215:in `connect' ...
Does anyone have any ideas why this would be the case? I've run out of things to try myself, so any help would be appreciated.