If <user>/<passwd>@xe works in sqlplus, you can use that in OGR. Its using the same libs to connect.
Try ogrinfo -ro OCI:<user>/<passwd>@xe Mike On 4/9/14, 8:01 PM, "Martin Landa" <[email protected]> wrote: >Hi, > >2014-04-10 1:40 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH ><[email protected]>: >> Hmm, this one should have work >> >> ogrinfo -ro OCI:user/password@geo1:1521/xe -sql "select count(*) from >>emp" >> >> >> You can use debug mode and see what might be going on. This is windows I >> see so try >> >> SET CPL_DEBUG=ON >> ogrinfo -ro OCI:user/password@geo1:1521/xe -sql "select count(*) from >>emp" > >unfortunately there is not so much info... > >OGR: Auto register C:\OSGeo4W_oci\\bin\gdalplugins\ogr_OCI.dll using >RegisterOGR >OCI. >OCI: Userid=<user>, Password=<passwd>, Database=geo1:1521/xe >ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified > in <unnamed> > >> Does sqlplus connect and allow access? > >This works... > >SQL> connect <user>/<passwd>@xe >Connected. > >Martin _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
