Re: [gnome-db] sybase

[Hugh Bragg <Hugh Bragg bibit com>]

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)


RPM build errors:
    Bad exit status from /var/tmp/rpm-tmp.8778 (%build)
------------------------------------------------------------------
This is the build script  /var/tmp/rpm-tmp.8778
----------------------------------------------------------------
#!/bin/sh

  RPM_SOURCE_DIR="/usr/src/redhat/SOURCES"
  RPM_BUILD_DIR="/usr/src/redhat/BUILD"
  RPM_OPT_FLAGS="-O2 -march=i386 -mcpu=i686"
  RPM_ARCH="i386"
  RPM_OS="linux"
  export RPM_SOURCE_DIR RPM_BUILD_DIR RPM_OPT_FLAGS RPM_ARCH RPM_OS
  RPM_DOC_DIR="/usr/share/doc"
  export RPM_DOC_DIR
  RPM_PACKAGE_NAME="libgda"
  RPM_PACKAGE_VERSION="0.2.95"
  RPM_PACKAGE_RELEASE="2"
  export RPM_PACKAGE_NAME RPM_PACKAGE_VERSION RPM_PACKAGE_RELEASE
  RPM_BUILD_ROOT="/var/tmp/libgda-0.2.95-root"
  export RPM_BUILD_ROOT

  set -x
  umask 022
  cd /usr/src/redhat/BUILD
cd libgda-0.2.95

# libtool workaround for alphalinux

export CFLAGS="-O2 -march=i386 -mcpu=i686 -I/usr/include/popt 
-I/usr/include/tcl -I/usr/include/gdbm -I/usr/freetds/include"
# Needed for snapshot releases.
if [ ! -f configure ]; then
  ./autogen.sh $ARCH_FLAGS --prefix=/usr --with-sybase=/usr/freetds
else
  ./configure $ARCH_FLAGS --prefix=/usr --with-sybase=/usr/freetds
fi

if [ "$SMP" != "" ]; then
  (make "MAKE=make -k -j $SMP"; exit 0)
  make
else
  make
fi
---------------------------------------------------------------------------------


On Friday 02 August 2002 17:27, Rodrigo Moya wrote:
> On Thu, 2002-08-01 at 17:31, Hugh Bragg wrote:
> > After a lot of updating my RH 7.1, I finally built a version of
> > libgda-0.2.95-1.i386.rpm using the src.rpm and included the
> > --with-sybase=%{_prefix} in the libgda.spec.
> > No gda-sybase-0.2.95-1.i386.rpm was built.
> > I installed libgda-0.2.95-1.i386.rpm and gnome-db does not connect to our
> > sybase database using the (Manager->New DSN).
> > I forget the exact syntax but I used 212.136.106.7:development and added
> > the u/p that works with sqsh.
>
> if no sybase rpm was built, then there is no sybase provider installed
>
> :-) please check the output of configure (when makinmg the package) to
>
> see the error message it shows when trying to detect the sybase
> libraries. It should display:
>
> Checking for Sybase files... found
>
> this check looks for ctpublic.h, so check where you've got it installed,
> and use:
>
> --with-sybase=/prefix/for/ctpublic
>
> cheers