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

[G. Allegri]

Exactly the same thing I do. I forgot to say that, thx Duarte ;)

2011/9/29 Duarte Carreira <DCarreira at edia.pt>

> 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>****
>
> 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/06db29eb/attachment.html>