[mapserver-users] OGR connection failed - OCI

[Jeff McKenna]

On 2017-05-23 10:35 AM, Jeff McKenna wrote:
> 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
>
>

Actually I now notice that your syntax is correct for specifying a 
different host or port ("OCI:username/password at host:port/sevice_name"), 
but I can't verify that locally.  So please ignore my first message.  -jeff




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