Re: [gnome-db] oracle9i

[Rodrigo Moya <rodrigo gnome-db org>]

On Tue, 2003-03-25 at 21:43, Steve Fosdick wrote:
> > 3) Is libgda-0.10.0 going to work with the oracle-provider from 0.11.0?
> 
> I don't know, I haven't tried it.
> 
afaik, it should work, since there haven't been incompatible changes
between 0.10 and 0.11, although, what do you want it for? Why not use
the same version (0.11) for both libgda and the oracle provider?

> > 
> > see below for install details.
> > 
> > james
> > 
> > 
> > $ rpm -q libgda mergeant libgnomedb
> > libgda-0.10.0-1
> > mergeant-0.10.0-1
> > libgnomedb-0.10.0-1
> > $ cd /usr/local/src/libgda-0.11.0
> > $ ./configure --with-oracle=/opt/oracle/product/9.2.0/
> > ...
> > $ make
> > ...
> > gda-freetds-provider.c:31:17: tds.h: No such file or directory
> > ...
>
ok, this seems a problem in the configure.in, which thinks freetds is
available whereas the tds.h file can't be found.

> > $ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds
> > ...
> > $ make
> > ...
> > gda-odbc.h:32:17: sql.h: No such file or directory
> > ...
>
the same again. I'm looking at this problem right now.

> > $ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds --without-odbc
> > ...
> >  Configuration summary
> >    Installation prefix = /usr/local
> >    Providers
> >       Default (XML) = yes
> >       FireBird = no
> >       FreeTDS = no
> >       IBM DB2 = no
> >       MDB (MS Access) = yes
> >       MySQL = no
> >       ODBC = no
> >       Oracle = yes
> >       PostgreSQL = no
> >       SQLite = yes
> >       Sybase = no
> >       xBase (dBase, Clipper, FoxPro) = no
> >       LDAP = yes
> > 
> > $ make
> > ...
> > In file included from gda-oracle.h:39,
> >                  from gda-oracle-provider.c:28:
> > gda-oracle-provider.h:27:17: oci.h: No such file or directory
> > ...
>
hmm, again the same :-( When running configure like this, is
$ORACLE_HOME set to some value? And what dir does it say it's found
oracle files in? (configure should output this info)

> > make[2]: *** [gda-oracle-provider.lo] Error 1
> > make[2]: Leaving directory `/usr/local/src/libgda-0.11.0/providers/oracle'
> > make[1]: *** [all-recursive] Error 1
> > make[1]: Leaving directory `/usr/local/src/libgda-0.11.0/providers'
> > make: *** [all-recursive] Error 1
> > $ find /opt/oracle/ -name oci.h
> > /opt/oracle/product/9.2.0/rdbms/demo/oci.h
> > ...
> > $ export ORACLE_HOME=/opt/oracle/product/9.2.0/
> > $ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds --without-odbc
> > ...
> > $ make
> > ...
> > $ make install
> > ...
> > # ln -s /usr/local/lib/libgda/providers/libgda-oracle.so /usr/lib/libgda/providers/
> > $ ls -l /usr/lib/libgda/providers/
> > total 284
> > -rwxr-xr-x    1 root     root        23598 Jan 28 13:19 libgda-default.so
> > -rwxr-xr-x    1 root     root        56078 Jan 28 13:18 libgda-freetds.so
> > -rwxr-xr-x    1 root     root        49499 Jan 28 13:18 libgda-mysql.so
> > -rwxr-xr-x    1 root     root        38286 Jan 28 13:19 libgda-odbc.so
> > lrwxrwxrwx    1 root     root           48 Mar 14 16:24 libgda-oracle.so -> /usr/local/lib/libgda/providers/libgda-oracle.so
> > -rwxr-xr-x    1 root     root        62268 Jan 28 13:19 libgda-postgres.so
> > -rwxr-xr-x    1 root     root        33725 Jan 28 13:19 libgda-sqlite.so
> > $ mergeant
> > ## add an oracle connect as PASSWORD=XXXX;USER=XXXX;TNSNAME=192.168.10.8
> > ## then test connection
> > (gnome-database-properties:16693): GLib-GObject-WARNING **: invalid cast from (NULL) pointer to `GObject'
> > 
> > (gnome-database-properties:16693): GLib-GObject-CRITICAL **: file gobject.c: line 1307 (g_object_unref): assertion `G_IS_OBJECT (object)' failed
> > 
> > (gnome-database-properties:16693): GModule-CRITICAL **: file gmodule.c: line 454 (g_module_close): assertion `module != NULL' failed
> > ## and I have to xkill gnome-database-properties
> > 
hmm, could you run gda-test in a terminal and see what it outputs when
it comes to open the oracle connection?

cheers