[mapserver-users] OGR connection failed - OCI

[GeoLady]

Hi,

thank for your reply. I have tried your connect string format before.
For connect string in this format CONNECTION "OCI:username/password at 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 at SID, I get error:

C:\Users\admin>ogrinfo OCI:username/password at SID
ERROR 1:  in <unnamed>
ERROR 1:  in <unnamed>
FAILURE:
Unable to open datasource `OCI:username/password at SID' with the following
drivers.
  -> netCDF
  -> AmigoCloud
  -> OCI
  -> PCIDSK
....

So I deleted both environment variables and I used connect string
format:"OCI:user/pass at host:port/SID"
It works with ogrinfo OCI:user/pass at 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.