[mapserver-users] OGR connection failed - OCI

[Jeff McKenna]

On 2017-05-23 10:12 AM, GeoLady wrote:
> 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?
>

Your CONNECTION syntax looks very odd to me.  Here is what works with 
MS4W[1] through an OGR connection to Oracle 12c:

   LAYER
     ...
     CONNECTIONTYPE OGR
     CONNECTION "OCI:username/password at SID"
     ...
   END

[1] http://ms4w.com


-jeff



-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/