Hi,
thank for your reply. I have tried your connect string format before.
For connect string in this format CONNECTION "OCI:username/password@SID" I
need TNS_ADMIN defined.
Instant oracle client has no tnsnames.ora. I created one:
<addressname> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = <hostname>)(Port = <port>))
)
(CONNECT_DATA =
(SERVICE_NAME = <service_name>)
)
)
And I set environment variable>
TNS_ADMIN=d:\oracle\instantclient_12_1-x64\network\admin\
ORACLE_HOME=d:\oracle\instantclient_12_1-x64\
When I do ogrinfo OCI:username/password@SID, I get error:
C:\Users\admin>ogrinfo OCI:username/password@SID
ERROR 1: in <unnamed>
ERROR 1: in <unnamed>
FAILURE:
Unable to open datasource `OCI:username/password@SID' with the following
drivers.
-> netCDF
-> AmigoCloud
-> OCI
-> PCIDSK
....
So I deleted both environment variables and I used connect string
format:"OCI:user/pass@host:port/SID"
It works with ogrinfo OCI:user/pass@host:port/SID but it doesn't work with
MapServer layer.
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/OGR-connection-failed-OCI-tp5321449p5321468.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-users
