unixodbc doesn't cooperate well with freedts

Binary package hint: unixodbc

i have working FreeDTS taken from repository of Ubuntu 9.10

using its tool called tsql I can connect to Microsoft SQL Server which runs on other machine and use it without any problem (running queries)

then i made it work with iODBC, again when i used iodbctest everything worked as it should

however openoffice doesn't use iODBC but unixodbc. and there are problems. after i created odbc source for unixodbc everything seems to be fine, only most of queries don't return any data. this happens from OpenOffice database and also using isql

for example when i launch query 'select count(*) from sometable' i get correct result, but when i launch 'select * from sometable' I get empty resultset.

it may be interesting that same problem i have when i use any qt application. qt available in ubuntu 9.10 is linked against libiodbc, not unixodbc, so may be that problem lies somewhere in FreeTDS too, i simply don't know where exactly to look. I decided to make this bugreport focus on unixodbc because freetds and iodbc tools work

please tell me what more you need for me (logs, tests etc.), i will try to help as much as i can

ProblemType: Bug
Architecture: i386
Date: Wed Nov 25 13:42:43 2009
DistroRelease: Ubuntu 9.10
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
Package: unixodbc 2.2.11-16ubuntu1
ProcEnviron:
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-15.50-generic
SourcePackage: unixodbc
Uname: Linux 2.6.31-15-generic i686
XsessionErrors:
 (gnome-settings-daemon:1278): GLib-CRITICAL **: g_propagate_error: assertion `src != NULL' failed
 (gnome-settings-daemon:1278): GLib-CRITICAL **: g_propagate_error: assertion `src != NULL' failed
 (polkit-gnome-authentication-agent-1:1351): GLib-CRITICAL **: g_once_init_leave: assertion `initialization_value != 0' failed
 (nautilus:1336): Eel-CRITICAL **: eel_preferences_get_boolean: assertion `preferences_is_initialized ()' failed