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

[Duarte Carreira]

The only thing I can add is that when I want to use in QGIS some format that GDAL/OGR supports but there's no GUI for it in QGIS, I create a VRT file. This file can have all the Oracle connection details, can be tested on the command line, and then loaded in QGIS.

Duarte

De: G. Allegri [mailto:giohappy at gmail.com]
Enviada: quinta-feira, 29 de Setembro de 2011 16:37
Para: Sandro Costa
Cc: Duarte Carreira; qgis-user at lists.osgeo.org; gordon.luckett at arrowgeomatics.com; jef at norbit.de
Assunto: Re: Connect to Oracle Spatial with QGIS

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<mailto: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<http://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/19d5a18d/attachment.html>