<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><span style="color: rgb(51, 51, 51);
font-family: Segoe, Helvetica, Arial, sans-serif; font-size:
13.513513565063477px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
16.985734939575195px; orphans: auto; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(244, 244, 244); display: inline
!important; float: none;">Jonathan - <br>
<br>
I'm very late to the party and I probably can't help you. But
anyway: On the danish QGIS "Yammer" list a member descibed how
to connect to Oracle from QGIS (The text is translated form
danish):<br>
<br>
...<br>
Type the following In the QGIS Oracle connection dialog:<br>
<br>
"Name" - Some arbitrary name for the connection <br>
"Database" - value of the parameter SERVICE_NAME from
tnsnames.ora<br>
"Host" - value of the parameter HOST</span><span style="color:
rgb(51, 51, 51); font-family: Segoe, Helvetica, Arial,
sans-serif; font-size: 13.513513565063477px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: 16.985734939575195px; orphans: auto;
text-align: left; text-indent: 0px; text-transform: none;
white-space: normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(244, 244,
244); display: inline !important; float: none;"><span
style="color: rgb(51, 51, 51); font-family: Segoe, Helvetica,
Arial, sans-serif; font-size: 13.513513565063477px;
font-style: normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: 16.985734939575195px;
orphans: auto; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(244, 244, 244); display: inline
!important; float: none;"> from tnsnames.ora</span></span><span
style="color: rgb(51, 51, 51); font-family: Segoe, Helvetica,
Arial, sans-serif; font-size: 13.513513565063477px; font-style:
normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: 16.985734939575195px;
orphans: auto; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(244, 244, 244); display: inline
!important; float: none;"><span style="color: rgb(51, 51, 51);
font-family: Segoe, Helvetica, Arial, sans-serif; font-size:
13.513513565063477px; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing: normal;
line-height: 16.985734939575195px; orphans: auto; text-align:
left; text-indent: 0px; text-transform: none; white-space:
normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(244,
244, 244); display: inline !important; float: none;"><span
style="color: rgb(51, 51, 51); font-family: Segoe,
Helvetica, Arial, sans-serif; font-size:
13.513513565063477px; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing: normal;
line-height: 16.985734939575195px; orphans: auto;
text-align: left; text-indent: 0px; text-transform: none;
white-space: normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(244,
244, 244); display: inline !important; float: none;"><br>
</span></span>"Port" - value of the parameter PORT </span><span
style="color: rgb(51, 51, 51); font-family: Segoe, Helvetica,
Arial, sans-serif; font-size: 13.513513565063477px; font-style:
normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: 16.985734939575195px;
orphans: auto; text-align: left; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(244, 244, 244); display: inline
!important; float: none;"><span style="color: rgb(51, 51, 51);
font-family: Segoe, Helvetica, Arial, sans-serif; font-size:
13.513513565063477px; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing: normal;
line-height: 16.985734939575195px; orphans: auto; text-align:
left; text-indent: 0px; text-transform: none; white-space:
normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(244,
244, 244); display: inline !important; float: none;">from
tnsnames.ora<br>
</span>"Username" - users oracle login name<br>
"Password" - </span><span style="color: rgb(51, 51, 51);
font-family: Segoe, Helvetica, Arial, sans-serif; font-size:
13.513513565063477px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
16.985734939575195px; orphans: auto; text-align: left;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(244, 244, 244); display: inline
!important; float: none;"><span style="color: rgb(51, 51, 51);
font-family: Segoe, Helvetica, Arial, sans-serif; font-size:
13.513513565063477px; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing: normal;
line-height: 16.985734939575195px; orphans: auto; text-align:
left; text-indent: 0px; text-transform: none; white-space:
normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(244,
244, 244); display: inline !important; float: none;">users
oracle</span> password</span><br>
...<br>
<br>
My own two cents: (Not using Oracle but MS-SQLServer and therefore
not directly related to your problem) You have two completely
separate setups for ODBC when different client programs is 32 bits
and 64 bits. You might have the same problem with Oracle ?<br>
<br>
Regards<br>
Bo Victor Thomsen<br>
Aestas-GIS<br>
Denmark<br>
<br>
Den 25-09-2013 11:53, Duarte Carreira skrev:<br>
</div>
<blockquote
cite="mid:A2C5C1FEBB05AA41A13D4F312D5F1A882DF691D9@AMSPRD0710MB365.eurprd07.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texto de balão Carácter";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.TextodebaloCarcter
{mso-style-name:"Texto de balão Carácter";
mso-style-priority:99;
mso-style-link:"Texto de balão";
font-family:"Tahoma","sans-serif";
mso-fareast-language:PT;}
span.EstiloCorreioElectrnico20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">Does qgis use gdal to access oracle data?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">If it does you can try to use the osgeo4w
console to try to connect with gdalinfo. See if that
presents a clearer error. Maybe the oracle plugin is
compiled against a different version of oracle…?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">If gdalinfo works, than you could create a .vrt
that wraps the connection to your oracle spatial table. Try
to open the .vrt in qgis… I have solved similar problems
this way (dxf files wouldn’t load unless through a .vrt).<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">I have used process explorer before to find
what dll is not being loaded or found… sometimes it worked
sometimes it didn’t…<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">Just launch it and filter processes until you
end up only with qgis related processes. You can find error
messages like file not found and others.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">Duarte<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
Jonathan Moules [<a class="moz-txt-link-freetext" href="mailto:jonathanmoules@warwickshire.gov.uk">mailto:jonathanmoules@warwickshire.gov.uk</a>]
<br>
<b>Enviada:</b> quarta-feira, 25 de Setembro de 2013 10:33<br>
<b>Para:</b> Bob and Deb<br>
<b>Cc:</b> Duarte Carreira; <a class="moz-txt-link-abbreviated" href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<b>Assunto:</b> Re: [Qgis-user] Oracle - QGIS connection<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Bob,<o:p></o:p></p>
<div>
<p class="MsoNormal">Thanks for the reply. Unfortunately
none of those things seems to have made a difference.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I've now installed QGIS on a second
machine, one that already has a working Oracle
administrator install that various other applications are
successfully using (i.e. FME). But QGIS on that machine
has the exact same problem with the exact same failure
mechanisms/errors.<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">So the issue seems to be QGIS
specific, but I don't know enough to be able to report
it as a useful bug report.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Cheers,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Jonathan<o:p></o:p></p>
<div>
<p class="MsoNormal">On 24 September 2013 18:14, Bob and
Deb <<a moz-do-not-send="true"
href="mailto:bobdebm@gmail.com" target="_blank">bobdebm@gmail.com</a>>
wrote:<o:p></o:p></p>
<div>
<p class="MsoNormal">Hello Jonathan,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">How about setting the
environment variable ORACLE_HOME to
c:\admin\apps\oracle32\product\11.2.0\client_1 and
TNS_ADMIN to the location of the directory that
contains tnsnames.ora? That is what I did and it
works fine. In the past I also had to rename the
oci.dll (or you can remove it) from c:\osgeo4w\bin
because it conflicted with the oci.dll in
%ORACLE_HOME%. Btw, we are connecting to Oracle
11.2.0 using OS authentication. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Bob<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal">On Tue, Sep 24, 2013 at
9:48 AM, Jonathan Moules <<a
moz-do-not-send="true"
href="mailto:jonathanmoules@warwickshire.gov.uk"
target="_blank">jonathanmoules@warwickshire.gov.uk</a>>
wrote:<o:p></o:p></p>
</div>
</div>
<blockquote style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0cm 0cm 0cm
6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<div>
<p class="MsoNormal">Hi Duarte,<o:p></o:p></p>
<div>
<p class="MsoNormal">Cunning, I'd not
played with the Python console before.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The QGIS path is the
same as the system one, though with
extra stuff pre-pended - Oracle is in
there just fine:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<blockquote
style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0cm 0cm 0cm
6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">'c:\Admin\Apps\Progs\QGISDU~1\apps\grass\grass-6.4.3\bin;c:\Admin\Apps\Progs\QGISDU~1\apps\msys\bin;c:\Admin\Apps\Progs\QGISDU~1\bin;<b>c:\admin\apps\oracle32\product\11.2.0\client_1\bin</b>;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\Program
Files (x86)\Microsoft Application
Virtualization Client;C:\Program Files
(x86)\ActivIdentity\SecureLogin\;C:\Program
Files\Intel\WiFi\bin\;C:\Program
Files\Common
Files\Intel\WirelessCommon\;c:\Admin\Apps\Progs\QGISDU~1\apps\msys\bin;c:\Admin\Apps\Progs\QGISDU~1\apps\Python27\Scripts;c:\Admin\Apps\Progs\QGISDU~1\apps\qgis\bin;c:\Admin\Apps\Progs\QGISDU~1\apps\grass\grass-6.4.3\lib'<o:p></o:p></p>
</blockquote>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Trying TNS ping from
within QGIS worked just fine too:<o:p></o:p></p>
</div>
<div>
<blockquote
style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0cm 0cm 0cm
6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">Attempting to
contact (DESCRIPTION = (ADDRESS =
(COMMUNITY = wcctcp.world) (PROTOCOL =
TCP) (Host = co-gistest-li2) (Port =
1521)) (CONNECT_DATA = (SID = gistest)
(GLOBAL_NAME = co_gistest.world)))<br>
OK (0 msec)<o:p></o:p></p>
</blockquote>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">----<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">If I try and "cheat"
and change my host from "co_gistest" to
the actual machine name:
"co-gistest-li2" - I get back an
ORA-12514 instead where it says it
doesn't know of the given host. But if I
enter random gibberish it goes back to a
ORA-12154.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Very confusing (but
it is Oracle).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Jonathan<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"
style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On 24 September
2013 17:28, Duarte Carreira <<a
moz-do-not-send="true"
href="mailto:DCarreira@edia.pt"
target="_blank">DCarreira@edia.pt</a>>
wrote:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">Can you compare
your path to what qgis is using?</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">In python console
type:</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">import os</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">os.environ["PATH"]</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">It seems to me qgis
is not finding your tns
settings… your’re setting these
up in tnsnames.ora?</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">You can try tnsping
from qgis and see what happens…
try print
os.popen(“tnsping…”).read() in
your python console…</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">Duarte</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
Jonathan Moules [mailto:<a
moz-do-not-send="true"
href="mailto:jonathanmoules@warwickshire.gov.uk"
target="_blank">jonathanmoules@warwickshire.gov.uk</a>]
<br>
<b>Enviada:</b> terça-feira, 24
de Setembro de 2013 17:16<br>
<b>Para:</b> Duarte Carreira<br>
<b>Cc:</b> <a
moz-do-not-send="true"
href="mailto:qgis-user@lists.osgeo.org"
target="_blank">qgis-user@lists.osgeo.org</a></span><o:p></o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><br>
<b>Assunto:</b> Re:
[Qgis-user] Oracle - QGIS
connection<o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi
Duarte,<o:p></o:p></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Yep
it works fine:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">sqlplus
username/password@co_gistest<o:p></o:p></p>
<div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Logs me
straight in, and
a trial select
confirms I'm in.<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">It's just
QGIS that is
having issues.<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">My PATH (this
is windows) is:<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">c:\admin\apps\oracle32\product\11.2.0\client_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program
Files
(x86)\Microsoft
Application
Virtualization
Client;C:\Program
Files
(x86)\ActivIdentity\SecureLogin\<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Am very
perplexed!<o:p></o:p></p>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Cheers,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;margin-bottom:12.0pt">Jonathan<o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On 24
September 2013
17:05, Duarte
Carreira <<a
moz-do-not-send="true" href="mailto:DCarreira@edia.pt" target="_blank">DCarreira@edia.pt</a>>
wrote:<o:p></o:p></p>
<div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">It
could be
environmental
variables
messed up when
launching
qgis… does
sqlplus work?</span><o:p></o:p></p>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"> </span><o:p></o:p></p>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US">Duarte</span><o:p></o:p></p>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"
lang="EN-US"> </span><o:p></o:p></p>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
Jonathan
Moules
[mailto:<a
moz-do-not-send="true"
href="mailto:jonathanmoules@warwickshire.gov.uk" target="_blank">jonathanmoules@warwickshire.gov.uk</a>]
<br>
<b>Enviada:</b>
terça-feira,
24 de Setembro
de 2013 16:00<br>
<b>Para:</b> <a
moz-do-not-send="true" href="mailto:qgis-user@lists.osgeo.org"
target="_blank">qgis-user@lists.osgeo.org</a><br>
<b>Assunto:</b>
Re:
[Qgis-user]
Oracle - QGIS
connection</span><o:p></o:p></p>
<div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi List,<o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I've done a
lot more
dabbling and
it simply
refuses to
work. I've now
got to the
point where
I've installed
the
Administrator
install of the
Oracle client.
Both QGIS and
the client are
32bit. But no
matter what I
keep getting
the Ora-12154
error.<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">If I try
tnsping, it
can resolve
the name just
fine, so I'm
not clear why
it is failing
with QGIS.<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I don't
remember what
I did
previously to
get it working
but I'm sure
it wasn't
anything like
this much
trouble.<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Anyone?<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thanks,<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Jonathan<o:p></o:p></p>
<div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On 23
September 2013
12:56,
Jonathan
Moules <<a
moz-do-not-send="true" href="mailto:jonathanmoules@warwickshire.gov.uk"
target="_blank">jonathanmoules@warwickshire.gov.uk</a>> wrote:<o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi List,<o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">This is
happening in
2.0.1 too. As
other things
can connect to
the database
from this
machine I have
to guess that
it is a QGIS
thing. I know
it worked
previously but
doesn't seem
to any more.<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Does it work
for other
folks? What
are you
entering into
the
parameters?<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thanks,<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Jonathan<o:p></o:p></p>
</div>
<div>
<div>
<div>
<div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On 28 August
2013 14:33,
Jonathan
Moules <<a
moz-do-not-send="true" href="mailto:jonathanmoules@warwickshire.gov.uk"
target="_blank">jonathanmoules@warwickshire.gov.uk</a>> wrote:<o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Anyone?<o:p></o:p></p>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I'm using
QGIS weekly
build d61cb25
on windows 7.<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thanks,<o:p></o:p></p>
</div>
<div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Jonathan<o:p></o:p></p>
</div>
</div>
</div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
<p
class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br>
<span
style="font-family:"Arial","sans-serif";color:#222222;background:white">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.</span><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br>
<span
style="font-family:"Arial","sans-serif";color:#222222;background:white">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.</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><br>
<span
style="font-family:"Arial","sans-serif";color:#222222">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.</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Qgis-user mailing list<br>
<a moz-do-not-send="true"
href="mailto:Qgis-user@lists.osgeo.org"
target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<span
style="font-family:"Arial","sans-serif";color:#222222;background:white">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.</span><o:p></o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>