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
ProcVersionSign
SourcePackage: unixodbc
Uname: Linux 2.6.31-15-generic i686
XsessionErrors:
(gnome-
(gnome-
(polkit-
(nautilus:1336): Eel-CRITICAL **: eel_preferences
Question information
- Language:
- English Edit question
- Status:
- Expired
- For:
- Ubuntu unixodbc Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
This question was originally filed as bug #488190.