DBI/unixODBC/FreeTDS weird problems on Linux

Hey :slight_smile:

I'm trying to migrate my rails app that uses an MS SQL server to Linux. I've setup freetds and unixodbc, installed ruby-dbi and ruby-odbc. isql and tsql work fine with this query:

SELECT TOP 1 * FROM Item WHERE (Item.Itemnumber = '9780444422286')

This query is taken from the error html output of my app when hitting the page that executes that query. It fails stating that,

Hi, I was having the same problem and found a fix(so to speak) here:

http://groups.google.com.au/group/rubyonrails-talk/browse_thread/thread/82db43270d2a0d59/2aa97ff83907fdc3?lnk=st&q=DBI%3A%3ADatabaseError%3A+INTERN+(0)+[RubyODBC]+No+data+found&rnum=3&hl=en#2aa97ff83907fdc3

Brad