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 <rgour...@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-boun...@lists.osgeo.org] De la part de Andrea > Peri > Envoyé : mercredi 14 octobre 2015 09:33 > À : gdal-dev@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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù ----------------- _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev