Martin, You need a bit more info in the connection
ogrinfo -ro OCI:user/password@hostname/sid -sql "select count(*) from emp" Where hostname is the server name (or something like localhost) and sid is the oracle instance name. if this is XE, then the sid is xe So try ogrinfo -ro OCI:user/password@localhost/xe -sql "select count(*) from emp" Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 4/9/14, 6:31 PM, "Martin Landa" <[email protected]> wrote: >Hi all, > >I would like to set up connection between OGR and Oracle Express 11g, >I downloaded Oracle SQL Developer and set up the connection, when I >try to connect to the database using user/password it works. > >When using OGR I entered to command line > >ogrinfo -ro OCI:user/password -sql "select count(*) from emp" > >but it failed with > >ERROR 1: ORA-12560: TNS:protocol adapter error > in <unnamed> > >Thanks in advance for any pointers! Martin > >-- >Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa >_______________________________________________ >gdal-dev mailing list >[email protected] >http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
