[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