[Qgis-user] QGIS and Oracle native connection

Jonathan Moules jonathanmoules at warwickshire.gov.uk
Wed May 8 03:24:08 PDT 2013


Bump.
Anyone? I'd love to try this and test it, but can't if I have no idea how
to even connect. Is there any documentation for it anywhere?
Thanks,
Jonathan


On 1 May 2013 15:35, Jonathan Moules <jonathanmoules at warwickshire.gov.uk>wrote:

> Hi List,
> I've got QGIS 1.9.0 based on a weekly nightly and it includes the new
> Oracle Spatial layer connection.
> Unfortunately the help is empty and I can't figure out what I should
> populate my fields with.
>
> There are 6 fields, Four are self explanatory, but I can't figure out the
> other two.
>
> Name - User-friendly string for me.
> Database - ???
> Host -???
>  Port - 1521
> Username - I know this.
> Password - I know this.
>
> My issue is with the "Database" and "Host" settings.
> In Oracle SQL Developer (from the same machine) I have the following that
> work:
> SID: gistest
> Hostname: 10.1.45.34
>
> But when I try this combination in QGIS, I get an ORA-12514 error ("TNS:listener
> does not currently know of service requested in connect descriptor").
>
> Any suggestions?
> Also, what do the bottom four checkboxes do? (The top two are self
> explanatory).
>
> Thanks,
> Jonathan
>

-- 
This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130508/086b13e1/attachment.html>


More information about the Qgis-user mailing list