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

[G. Allegri]

Good to know Sandro!
It would helpful to have your hints on the Qgis wiki. I could submit it on
the Qgis developers ML

giovanni

2011/10/7 Sandro Costa <sandro.costa at gmail.com>

> Dear friends,
>
> Finally I got it!
>
> *Quantum GIS 1.7.1 with OSGeo4W installer:*
>
> I have the Oracle Client installed on the machine. So, the *path *to the
> oci.dll and oraociei11.dll libraries was automatically set.
> I installed the package OSGeo4W!
> So, on QGIS, in Add Vector Layer tool, appeared the type "Oracle Spatial"
> in Base Data!
> I has can finally connect to Oracle Spatial with Quantum GIS 1.7.1!
> I managed to connect to two databases on two different servers!
>
> I investigated the differences between the standalone and OSGeo4W
> installations! The standalone QGIS 1.7.1 not presented the option to connect
> to Oracle Spatial!
>
> *Standalone Quantum GIS 1.7.1*:
>
> I did a fresh install of QGIS on a clean machine containing the Oracle
> Client 11g R1 (a machine that had never received a QGIS installation or
> OSGeo4W!).
> So *I copied the ogr_OCI.dll and gdal_GEOR.dll libraries* from the QGIS
> installed by OSGeo4W into the folder *\Bin\gdalplugins\1.8* of the
> standalone QGIS 1.7.1
> I enabled the QGIS complements. So, the QGIS can correctly connect to
> Oracle!
> I think the developers could insert these libraries in the standalone QGIS
> installer and so end this unnecessary trouble!
> This procedure is not new! Many people have reported this method! But it
> did not work! Maybe this newer version has solved problems.
>
> Regards,
>
> Sandro.
>
>
> 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/20111007/3fa7d641/attachment.html>