Hi Duarte, Cunning, I'd not played with the Python console before. The QGIS path is the same as the system one, though with extra stuff pre-pended - Oracle is in there just fine:
'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; > *c:\admin\apps\oracle32\product\11.2.0\client_1\bin*;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' Trying TNS ping from within QGIS worked just fine too: > 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))) > OK (0 msec) ---- 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. Very confusing (but it is Oracle). Jonathan On 24 September 2013 17:28, Duarte Carreira <dcarre...@edia.pt> wrote: > Can you compare your path to what qgis is using?**** > > ** ** > > In python console type:**** > > import os**** > > os.environ["PATH"]**** > > ** ** > > It seems to me qgis is not finding your tns settings… your’re setting > these up in tnsnames.ora?**** > > ** ** > > You can try tnsping from qgis and see what happens… try print > os.popen(“tnsping…”).read() in your python console…**** > > ** ** > > Duarte**** > > ** ** > > *De:* Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] > *Enviada:* terça-feira, 24 de Setembro de 2013 17:16 > *Para:* Duarte Carreira > *Cc:* qgis-user@lists.osgeo.org > > *Assunto:* Re: [Qgis-user] Oracle - QGIS connection**** > > ** ** > > Hi Duarte,**** > > ** ** > > Yep it works fine:**** > > sqlplus username/password@co_gistest**** > > ** ** > > Logs me straight in, and a trial select confirms I'm in.**** > > It's just QGIS that is having issues.**** > > ** ** > > My PATH (this is windows) is:**** > > 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\**** > > ** ** > > Am very perplexed!**** > > Cheers,**** > > Jonathan**** > > On 24 September 2013 17:05, Duarte Carreira <dcarre...@edia.pt> wrote:**** > > It could be environmental variables messed up when launching qgis… does > sqlplus work?**** > > **** > > Duarte**** > > **** > > *De:* Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] > *Enviada:* terça-feira, 24 de Setembro de 2013 16:00 > *Para:* qgis-user@lists.osgeo.org > *Assunto:* Re: [Qgis-user] Oracle - QGIS connection**** > > **** > > Hi List,**** > > 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.**** > > **** > > If I try tnsping, it can resolve the name just fine, so I'm not clear why > it is failing with QGIS.**** > > I don't remember what I did previously to get it working but I'm sure it > wasn't anything like this much trouble.**** > > **** > > Anyone?**** > > Thanks,**** > > Jonathan**** > > **** > > **** > > On 23 September 2013 12:56, Jonathan Moules < > jonathanmou...@warwickshire.gov.uk> wrote:**** > > Hi List,**** > > 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.**** > > **** > > Does it work for other folks? What are you entering into the parameters?** > ** > > **** > > Thanks,**** > > Jonathan**** > > **** > > **** > > On 28 August 2013 14:33, Jonathan Moules < > jonathanmou...@warwickshire.gov.uk> wrote:**** > > Anyone?**** > > I'm using QGIS weekly build d61cb25 on windows 7.**** > > **** > > 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.**** > > ** ** > > > 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.**** > -- 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.
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
