[Qgis-developer] Oracle connection fails for OGR import into PostGIS

Paolo Cavallini cavallini at faunalia.it
Thu Apr 16 10:08:46 PDT 2015


Hi all.
An Oracle layer can be dragged and dropped to PostGIS through DB
Manager. The same layer, once loaded in QGIS, should be imported through
the new OGR importer in Processing, but this method (which should be
much more efficient) fails:

GDAL execution console output
FAILURE:
Unable to open datasource `dbname='AUI.ESERCIZIO' host=oraaui.enel
port=1523 user='georef' password='aui_georef$1' estimatedmetadata=true
srid=8307 type=POINT table="GEOREF"."GEO_NODI_BT" (GEOMETRY_WGS84) sql='
with the following drivers.
  -> OCI
  -> SOSI
...

Apparently a bug in the Processing tool, or there are other explanations?

Thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html


More information about the Qgis-developer mailing list