[gdal-dev] [EXTERNAL] oci and oracle express 11
Martin Landa
landa.martin at gmail.com
Wed Apr 9 17:01:48 PDT 2014
Hi,
2014-04-10 1:40 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
<Michael.Smith at erdc.dren.mil>:
> Hmm, this one should have work
>
> ogrinfo -ro OCI:user/password at 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 at 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
More information about the gdal-dev
mailing list