[mapserver-users] OGR connection failed - OCI

[GeoLady]

Hi,

when I test my mapfile (with browser) with a layer 'ULICE' which connect to
Oracle Database I have this error: msDrawMap(): Image handling error. Failed
to draw layer named 'ULICE'. msOGRFileOpen(): OGR error. Open failed for OGR
connection in layer `ULICE'. File not found or unsupported format. Check
server logs.

I download MapServer from page http://gisinternals.com. And I take this
release-1800-x64-gdal-2-1-3-mapserver-7-0-4.zip.
When I do ogrinfo --formats, I have OCI in the list. And when I test
database connection with ogrinfo OCI:user/pass at host:port/SID, it is too slow
but the connection is successfull. 

Can someone help, please?

http://localhost/mapserver/scripts/mapserv.exe?map=D:\MapServer\map\oratest2.map&mode=map

oratest2.map >
MAP
  IMAGETYPE      PNG
  EXTENT         -422441 -1246473 -419074 -1245427
  SIZE           600 300
  FONTSET        "D:\MapServer\fonts\font.list"
  CONFIG         "PROJ_LIB" "D:\MapServer\scripts\proj\nad"
  CONFIG         "MS_ERRORFILE" "D:\MapServer\tmp\ms_error.txt"
  CONFIG         "GDAL_DRIVER_PATH" "D:\MapServer\scripts\gdalplugins" 
  CONFIG         "CPL_DEBUG" "ON"
  DEBUG		 5	
  IMAGECOLOR	 192 192 192
  
PROJECTION
   "init=epsg:2065"
  END


LAYER
  NAME "ULICE"
  TYPE  LINE
  STATUS DEFAULT
  CONNECTION "OCI:user/pass at host:port/SID"
  CONNECTIONTYPE OGR
  DATA "GM_U"
  DEBUG 5
  CLASS
    NAME "Ulice"
    STYLE
      COLOR 255 128 0
    END # Style
  END # Class
END # Layer

END

C:\Users\admin>mapserv -v
MapServer version 7.0.4 OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ
SUPPORTS=AGG SUPPORTS=FREETY
PE SUPPORTS=CAIRO SUPPORTS=SVG_SYMBOLS SUPPORTS=SVGCAIRO SUPPORTS=ICONV
SUPPORTS=FRIBIDI SUPPORTS=WM
S_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT
SUPPORTS=WCS_SERVER SUPPORTS=SO
S_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG
INPUT=POSTGIS INPUT=OGR INPUT=GD
AL INPUT=SHAPEFILE

My environment is >
windows server 2012 64bit
mapserver 7.0.4 64bit + gdal 2.1.3
instant oracle client 12.1.0.2 64bit
oracle database 12.1.0.2 64bit

IIS logs do not mention the error, neither Windows Log, neither Oracle
Client logs.





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/OGR-connection-failed-OCI-tp5321449.html
Sent from the Mapserver - User mailing list archive at Nabble.com.