[Qgis-user] Re: Connect to Oracle Spatial with QGIS

G. Allegri giohappy at gmail.com
Thu Sep 29 08:36:35 PDT 2011


Hi Sandro,
in my experience the GDAL/OGR driver for Oracle (OCI driver) doesn't work
very well. It depends on what you need it for, but for example it was a pain
vieweing an Oracle layer in QGis. I don't know if things have improved.
In Java based projects the drivers are generelly better (i.e. Gvsig, Kosmo,
etc.) maybe because it's easier to mantin them rather then the OCI (C/C++)
interface.

Anyway, the first thing to do is to download the Oracle Client drivers from
Oracle [1]. After having installed it you will find the required libraries
for GDAL to use the driver. I have only experience with Oracle for Windows,
where for Oracle 11g the DLL is oraociei11.dll

If GDAL find the shared library on the bin path, it will activate the OCI
driver, and that's the end. At this point you can use an Oracle layer
thorugh whatever client using GDAL.

Giovanni

[1]
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html


2011/9/29 Sandro Costa <sandro.costa at gmail.com>

> Lady and Gentlemen,
>
> Sorry if I'm being intrusive! I got your emails in a thread.
>
> I am trying to connect to Oracle Spatial with QGIS (Why Kosmo can do it?).
>
> I have already sent several emails to Oracle, OSGeo, gdal.org, qgisbrasil.
> And I've read various threads of the QGIS forums.  But I did not succeed!
>
> I know you will say to me:  Use GDAL / OGR or OSGeo4W package!   I've
> installed it!
>
> And I ask you: And now? How to use?
>
> I'm not a developer! I am a common GIS user!
>
> What I need is a cookbook, step-by-step:
> 1 - Where to find what I need!
> 2 - How to install them!
> 3 - How to configure QGIS to use them!
> 4 - How to connect Oracle Spatial through QGIS!
>
> Can anyone help me?
>
> Sandro Costa
> Brazil
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110929/7bba284e/attachment.html>


More information about the Qgis-user mailing list