[freetds] FreeTDS 0.63 and OpenOffice

Martin Spott Martin.Spott at uni-duisburg.de
Mon Aug 9 11:50:42 EDT 2004

"ZIGLIO, Frediano, VF-IT" wrote:
> I did some (rapid) tests using current 0.63 version and OpenOffice 1.1.0
> (from Fedora Core 1).
> It display all available tables and I can compose queries without any
> crash (I did it repeately).

Probably we're running things in in different environments. Over here I
didn't succeed in displaying any tablename within OpenOffice.
I'm currently using OpenOffice-1.1.1, current FreeTDS CVS and
unixODBC-2.2.3 (distributed with SuSE-8.2) against a Sybase-
ESD#6 database on Linux. I'm configuring FreeTDS with these parameters:

./configure --prefix=/opt/freetds --enable-shared --disable-static \
--enable-sybase-compat --with-unixodbc=/usr/lib/unixODBC \
--enable-developing --disable-libiconv

.... errrm, should I use FreeTDS 0.63 release instead ?
I have a little database 'MasTest' which belongs to the owner 'mas' -
this is the owner's default database. 'mas' logs into the database with
a password 'dummy4' and tries to browse his database tables - which
succeeds in 'sqsh':

gluehbirne: 17:48:24 ~> id
uid=525(mas) gid=500(buro) Gruppen=500(buro),11(tape),14(uucp),41(xok),42(trusted),55(dba),504(vtol),504(vtol),505(cdwrite)
gluehbirne: 17:48:26 ~> env LANG=german sqsh -SSYBASE -U$LOGNAME -b -B -X
[21] SYBASE.MasTest.1> sp__helptable;
 Table Name              Rows     Res KB Usd KB Rows/KB Segment       Cr Date
 ----------------------- -------- ------ ------ ------- ------------- -------
 ARTIKEL                 0        32     4        0.00  default       16Jul04
 BERICHT                 0        64     8        0.00  default       27Apr04

I am using TDS version 5.0 with FreeTDS.
Maybe you want to post the steps you undertake to browse your tables,
maybe it's also woth noting the default character set ?
I'd be happy to provide additional log files if you think this would

 Unix _IS_ user friendly - it's just selective about who its friends are !

More information about the FreeTDS mailing list