<div dir="ltr">Hi Duarte,<div><br><div>Yep it works fine:</div><div>sqlplus username/password@co_gistest<br><div class="gmail_extra"><div><br></div><div>Logs me straight in, and a trial select confirms I'm in.</div><div>
It's just QGIS that is having issues.</div><div><br></div><div>My PATH (this is windows) is:</div><div>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\<br>
</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Am very perplexed!</div>Cheers,</div><div class="gmail_extra">Jonathan<br><br><div class="gmail_quote">On 24 September 2013 17:05, Duarte Carreira <span dir="ltr"><<a href="mailto:DCarreira@edia.pt" target="_blank">DCarreira@edia.pt</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="PT" link="blue" vlink="purple">
<div>
<p class=""><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">It could be environmental variables messed up when launching qgis… does sqlplus work?<u></u><u></u></span></p>
<p class=""><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class=""><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Duarte<u></u><u></u></span></p>
<p class=""><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class=""><b><span style="font-size:10pt;font-family:Tahoma,sans-serif">De:</span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif"> Jonathan Moules [mailto:<a 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 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<u></u><u></u></span></p><div><div class="h5">
<p class=""><u></u> <u></u></p>
<div>
<p class="">Hi List,<u></u><u></u></p>
<div>
<p class="">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.<u></u><u></u></p>
</div>
<div>
<p class=""><u></u> <u></u></p>
</div>
<div>
<p class="">If I try tnsping, it can resolve the name just fine, so I'm not clear why it is failing with QGIS.<u></u><u></u></p>
</div>
<div>
<p class="">I don't remember what I did previously to get it working but I'm sure it wasn't anything like this much trouble.<u></u><u></u></p>
</div>
<div>
<p class=""><u></u> <u></u></p>
</div>
<div>
<p class="">Anyone?<u></u><u></u></p>
</div>
<div>
<p class="">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="">Jonathan<u></u><u></u></p>
<div>
<div>
<p class=""><u></u> <u></u></p>
</div>
<p class="" style="margin-bottom:12pt"><u></u> <u></u></p>
<div>
<p class="">On 23 September 2013 12:56, Jonathan Moules <<a href="mailto:jonathanmoules@warwickshire.gov.uk" target="_blank">jonathanmoules@warwickshire.gov.uk</a>> wrote:<u></u><u></u></p>
<div>
<p class="">Hi List,<u></u><u></u></p>
<div>
<p class="">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.<u></u><u></u></p>
</div>
<div>
<p class=""><u></u> <u></u></p>
</div>
<div>
<p class="">Does it work for other folks? What are you entering into the parameters?<u></u><u></u></p>
</div>
<div>
<p class=""><u></u> <u></u></p>
</div>
<div>
<p class="">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="">Jonathan<u></u><u></u></p>
</div>
<div>
<div>
<div>
<div>
<div>
<p class=""><u></u> <u></u></p>
</div>
<p class="" style="margin-bottom:12pt"><u></u> <u></u></p>
<div>
<p class="">On 28 August 2013 14:33, Jonathan Moules <<a href="mailto:jonathanmoules@warwickshire.gov.uk" target="_blank">jonathanmoules@warwickshire.gov.uk</a>> wrote:<u></u><u></u></p>
<div>
<p class="">Anyone?<u></u><u></u></p>
<div>
<p class="">I'm using QGIS weekly build d61cb25 on windows 7.<u></u><u></u></p>
</div>
<div>
<p class=""><u></u> <u></u></p>
</div>
<div>
<p class="">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="">Jonathan<u></u><u></u></p>
</div>
</div>
</div>
<p class=""><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class=""><u></u> <u></u></p>
</div>
</div>
</div>
</div></div><p class=""><br>
<span style="font-family:Arial,sans-serif;color:rgb(34,34,34);background-color: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><u></u><u></u></p>
</div>
</div>
</blockquote></div><br></div></div></div></div>
<br>
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)">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>