[gnome-db]Oracle provider update

[Bob Jones <bobjones68 yahoo com>]

Hello all,

I have fixed the configure file for libgda 0.2.10 to work with Oracle 
8.1.7.  These changes should also work for the 9i Application Server on 
the Linux platform when it becomes available since 9i uses the 8i 
database server.  I would appreciate it greatly if these changes could 
be tested and any problems forwarded on to me.

One thing I noticed is that for the DSN you might need to add 
'sid=<service ID>' and possibly 'service_name=<service name>' before 
that if your connecting to a non-local database.

Over the next few months, as I get the time, I will be cleaning up the 
SQL for the oracle provider and posting them as well.

Thanks in advance for your input.
Bob Jones

-------------------------------------
#begin Configure section for Oracle 8i   (line 6847)

# Check whether --with-oracle or --without-oracle was given.
if test "${with_oracle+set}" = set; then
 withval="$with_oracle"

if test $withval != yes
then
   dir=$withval
else
   dir="/usr/local"
fi
echo $ac_n "checking for ORACLE installation""... $ac_c" 1>&6
echo "configure:6859: checking for ORACLE installation" >&5
for d in $dir $ORACLE_HOME /opt/oracle
do
   if test -f $d/lib/libclntsh.so
   then
       echo "$ac_t""found ORACLE in $d" 1>&6
       oracledir=$d
       break
   fi
done
if test x$oracledir = x
then
   echo "configure: warning: ORACLE backend not used" 1>&2
else
   cat >> confdefs.h <<\EOF
#define HAVE_ORACLE 1
EOF

   ORACLE_CFLAGS="-I${ORACLE_HOME}/rdbms/demo \
              -I${ORACLE_HOME}/rdbms/public \
              -I${ORACLE_HOME}/plsql/public \
              -I${ORACLE_HOME}/network/public"
   ORACLE_LIBS="-L${ORACLE_HOME}/lib -lm -ldl -lserver8 -lclient8 \
                    -lgeneric8 -lcommon8 -lvsn8 -lagent8 -lmm -lclntst8 \
            -lslax8 -lsql8 -lcore8 -lnls8 -lplc8 -lplp8 -lpls8 \
                    -lpsa8"
fi

fi




if test x$oracledir != x; then
 ORACLE_TRUE=
 ORACLE_FALSE='#'
else
 ORACLE_TRUE='#'
 ORACLE_FALSE=
fi

---------------------------------





_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com