[freetds] missing data w/ sqlserver2005 and unixodbc
magic_hat60622 at yahoo.com
Fri Mar 30 18:01:51 EDT 2007
Hi, everyone. I'm using freetds 0.63, and unixodbc to connect to sqlserver 2005 with a Ruby on Rails application.
My connection is fine when I test with tsql, and many queries generated by the Rails app work okay.
However, when it issues this:
SELECT TOP 20 * FROM ccc.Item WHERE (ccc.Item.CategoryID = 3 AND (ccc.Item.Quantity>0)) ORDER BY Web_IMG_SRC desc
I get 'no data found'.
I've confirmed that the query returns data when I execute using isql.
The freetds log file generated from this operation is 3.5MB, so I'm a little unclear as to where to begin looking for problems, and how I might address them.
Thanks for any help you can offer.
Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.
More information about the FreeTDS