[Qgis-user] QGIS and Oracle native connection

[Jonathan Moules]

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/20130501/6198c3de/attachment.html>