[gdal-dev] [EXTERNAL] oci and oracle express 11

[Smith, Michael ERDC-RDE-CRREL-NH]

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" <landa.martin at gmail.com> wrote:

>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