[Bug 488190] [NEW] unixodbc doesn't cooperate well with freedts

[Selmi]

Public bug reported:

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

** Affects: unixodbc (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386

-- 
unixodbc doesn't cooperate well with freedts
https://bugs.launchpad.net/bugs/488190
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to unixodbc in ubuntu.