[Qgis-developer] [Fwd: [Qgis-user] qgis oracle connection]

[Jürgen E. Fischer]

Hi Richard,

On Mon, 01. Dec 2008 at 11:06:50 +0100, Richard Duivenvoorde wrote:
> forwarded from user list, as there was no response there.
> Any experience here?

You need a OGR compiled with Oracle support. 

> what is the current status of qgis abilities to connect to Oracle and 
> show (edit????) it's geometries?

> I've stumbled upon Stephan's plugin (somewhere around version 0.8 
> looking at the screenshots):
> http://www.holl-land.de/blog/index.php/2006/12/23/oracle-plugin-for-qgis/

I took a quick look.  I think that allows to browse the database for
geometry tables, select the one you'd like to add and then creates an
URI for the OGR driver and create a vector layer with it.

There's also the ogr plugin branch with also does something like that,
but for more OGR drivers (eg. mysql).

But given a Oracle enabled GDAL and knowing the URI syntax you need to
access the Oracle table/OGR layer you want, you might get away with a
simple plugin that allows to specify an URI and tries to add a vector
layer using it.


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-20
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502