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

[Mateusz Łoskot]

On 10 April 2014 11:27, Martin Landa <landa.martin at gmail.com> wrote:
> Hi,
>
> 2014-04-10 3:27 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH
> <Michael.Smith at erdc.dren.mil>:
>> 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
>
> I already tried that but without success...
>
> ERROR 1: ORA-12154: TNS:could not resolve the connect identifier specified
>  in <unnamed>

Try easy connection mode with

username/password at 127.0.0.1:1521/xe

Also, check you are using the same type of binaries (32 or 64 bit) of
GDAL/OGR and InstantClient. AFAIR, they don't mix.

Also, for development purposes, I usually replace hostname with IP address
in tnsnames.ora, as the name resolving proved troublesome for me.

Best regards,
-- 
Mateusz  Łoskot, http://mateusz.loskot.net