[gdal-dev] How connect to a remote oracle with spatial

[Andrea Peri]

Hi,

thx for help.

The solution reported me from Rèmy work good.
My error was to use the ":" instead of "/" to separate username and password.
So the right sintax is:

ogrinfo OCI:username/password@"(DESCRIPTION = (ADDRESS_LIST = (ADDRESS
= (PROTOCOL = TCP)(HOST = <IP server dbms>)(PORT = <listener
port>)))(CONNECT_DATA = (SID =<the sid of dbms>))):<schema>.<table>"

Regards.


2015-10-14 9:36 GMT+02:00 Rémy Gourrat <rgourrat at ag-carto.fr>:
> Hi,
>
> You put a : instead /
>
> You must use this syntax :
>
> ogrinfo OCI:username/password@
>
>
>
> -----Message d'origine-----
> De : gdal-dev [mailto:gdal-dev-bounces at lists.osgeo.org] De la part de Andrea Peri
> Envoyé : mercredi 14 octobre 2015 09:33
> À : gdal-dev at lists.osgeo.org
> Objet : [gdal-dev] How connect to a remote oracle with spatial
>
> Hi,
> I'm trying to test using gdal the access to an oracle dbms.
>
> To do this I use the ogrinfo and try this sintax but without success.
>
> ogrinfo OCI:username:password@"(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <IP server dbms>)(PORT = <listener
> port>)))(CONNECT_DATA = (SID =<the sid of dbms>))):<schema>.<table>"
>
> The server return
>
> ERROR 1: ORA-01005: null password given; logon denied  in <unnamed>
>
> I guess the sintax is wrong , but don't know how otherwise pass to the connection the url and the SID to the dbms
>
> Any help is welcome.
>
> --
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------