[Qgis-user] Re: qgis oracle connection

[Duarte Carreira]

I haven't used OCI/SDO GEOM for a few year so can't really say about performance. ArcSDE driver is working good though...

Duarte

De: G. Allegri [mailto:giohappy at gmail.com]
Enviada: segunda-feira, 13 de Junho de 2011 10:41
Para: Duarte Carreira
Cc: GordonL; qgis-user at lists.osgeo.org
Assunto: Re: [Qgis-user] Re: qgis oracle connection

In my experience, the real problem with OGR/OCI interface (the code to connect oracle drivers) is its slowness, in particular for viewing porpuses, where there's a lot of panning/zooming/querying.
Duarte, what's your experience with that?

giovanni
2011/6/13 Duarte Carreira <DCarreira at edia.pt<mailto:DCarreira at edia.pt>>
Gordon,

I've had success using OGR .vrt files in QGIS. Create a .vrt file that connects to a single spatial table in your databases, and try to load it in QGIS. As long as the .vrt file works in command-line OGR it should also work in QGIS...

More info: http://www.gdal.org/ogr/drv_vrt.html.

Duarte

-----Mensagem original-----
De: GordonL [mailto:gordon.luckett at arrowgeomatics.com<mailto:gordon.luckett at arrowgeomatics.com>]
Enviada: sexta-feira, 10 de Junho de 2011 21:21
Para: qgis-user at lists.osgeo.org<mailto:qgis-user at lists.osgeo.org>
Assunto: [Qgis-user] Re: qgis oracle connection

Thanks, I will keep looking.
QGIS is great - I just discovered how to put in my custom coordinate systems
and I'm very excited.

I would love to connect to either SQL Server 2008 (Geom or Geog) or SDO_GEOM
in Oracle.

gordon



--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/qgis-oracle-connection-tp2038299p6463655.html
Sent from the qgis-user mailing list archive at Nabble.com.

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org<mailto:Qgis-user at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/qgis-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110613/7acd8998/attachment.html>