Re: [gnome-db] sybase -> freetds for gnome 2/libgda in cvs

[Holger Thon <holger thon gnome-db org>]

Hello,

the sybase provider will not compile with freetds, unfortunately. The
freetds implementation of ct-library is not complete, hence some
definitions are missing.

You need to install OpenClient 11.x to compile the provider. It's better
to deinstall freetds first to avoid problems with dynamically linked
programs. So keep sure that your library-paths must be set correctly if 
you need OpenClient and freetds installed in parallel. Best is to have 
freetds installed in a directory not included in the library paths and 
use freetds based programs with wrapper scripts.

I've just started work on the freetds-provider for the Gnome 2 version
of libgda in cvs branch HEAD. It's far from complete (e.g. needs some 
tuning on error handling and quite some types added for dealing with 
data). 
Though, it can already connect, execute simple select queries, and has 
a tables and types schema. It is based on the core tds library of freetds,
tested with freetds 0.53 and ASE 11.9.2.

Regards
Holger

On Tue, Aug 06, 2002 at 02:59:16PM +0200, Hugh Bragg wrote:
> From: Hugh Bragg <Hugh Bragg bibit com>
> To: Rodrigo Moya <rodrigo gnome-db org>
> Subject: Re: [gnome-db] sybase
> Cc: GDA <gnome-db-list gnome org>
> Date: Tue, 6 Aug 2002 14:59:16 +0200
> 
> Thanks, I got a lot further.
> I installed /home/hugh/freetds-0.51-1.asp.i386.rpm and set prefix to 
> /usr/freetds
> This time there is a compile error, possibly the libraries I used.
> Which libraries should I use. My sybase installation /usr/opt/sybase-11.9.2/ 
> doesn't have the include files so I use the freetds.
> 
> Otherwise, I have no idea what the problem is.
> 
> Thankyou,
> Hugh.
> ------------------------------------------------------------------------
> ...
> Making all in gda-sybase-server
> make[3]: Entering directory 
> `/usr/src/redhat/BUILD/libgda-0.2.95/providers/gda-sybase-server'
> gcc -DHAVE_CONFIG_H -I. -I. -I../.. -I/usr/freetds/include      
> -I/usr/include/glib-1.2 -I/usr/lib/glib/include -D_REENTRANT 
> -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include 
> -I/usr/X11R6/include -I/usr/include/gnome-xml -I/usr/include/gconf/1 
> -I/usr/include/glib-1.2 -I/usr/lib/glib/include -I/usr/include/orbit-1.0 
> -I/usr/include/gnome-1.0 -DNEED_GNOMESUPPORT_H -I/usr/lib/gnome-libs/include 
> -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include 
> -I/usr/X11R6/include -I/usr/include/gdk-pixbuf-1.0 -I/usr/include/gnome-xml 
> -I/usr/include -I/usr/include/orbit-1.0   -I../../lib/gda-common  
> -I../../lib/gda-common  -I../../lib/gda-server  -I../../lib/gda-server     
> -O2 -march=i386 -mcpu=i686 -I/usr/include/popt -I/usr/include/tcl 
> -I/usr/include/gdbm -I/usr/freetds/include -c gda-sybase-command.c
> gcc -DHAVE_CONFIG_H -I. -I. -I../.. -I/usr/freetds/include      
> -I/usr/include/glib-1.2 -I/usr/lib/glib/include -D_REENTRANT 
> -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include 
> -I/usr/X11R6/include -I/usr/include/gnome-xml -I/usr/include/gconf/1 
> -I/usr/include/glib-1.2 -I/usr/lib/glib/include -I/usr/include/orbit-1.0 
> -I/usr/include/gnome-1.0 -DNEED_GNOMESUPPORT_H -I/usr/lib/gnome-libs/include 
> -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include 
> -I/usr/X11R6/include -I/usr/include/gdk-pixbuf-1.0 -I/usr/include/gnome-xml 
> -I/usr/include -I/usr/include/orbit-1.0   -I../../lib/gda-common  
> -I../../lib/gda-common  -I../../lib/gda-server  -I../../lib/gda-server     
> -O2 -march=i386 -mcpu=i686 -I/usr/include/popt -I/usr/include/tcl 
> -I/usr/include/gdbm -I/usr/freetds/include -c gda-sybase-connection.c
> gda-sybase-connection.c: In function `gda_sybase_connection_reopen':
> gda-sybase-connection.c:821: `CS_MAX_CHAR' undeclared (first use in this 
> function)
> gda-sybase-connection.c:821: (Each undeclared identifier is reported only once
> gda-sybase-connection.c:821: for each function it appears in.)
> gda-sybase-connection.c:1017: `CS_SERVERNAME' undeclared (first use in this 
> function)
> make[3]: *** [gda-sybase-connection.o] Error 1
> make[3]: Leaving directory 
> `/usr/src/redhat/BUILD/libgda-0.2.95/providers/gda-sybase-server'
> make[2]: *** [all-recursive] Error 1
> make[2]: Leaving directory `/usr/src/redhat/BUILD/libgda-0.2.95/providers'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/usr/src/redhat/BUILD/libgda-0.2.95'
> make: *** [all-recursive-am] Error 2
> error: Bad exit status from /var/tmp/rpm-tmp.8778 (%build)
>