[Mapserver-users] Mapserver - Oracle through OGR

[Bart van den Eijnden]

Hi Zak,

Frank Warmerdam already replied to me but off-list.

The problem seems to be that I have to recompile Mapserver against the 
modified GDAL/OGR with Oracle Spatial support. I thought I only had to 
build a new gdal11.dll.

Best regards,
Bart

On Mon, 16 Feb 2004 23:32:48 -0500, Zak James <zak-ms at hoppsan.org> wrote:

> Bart:
>
> What result do you get if you try to run your ovf file through ogrinfo, 
> instead of accessing the OCI driver directly?
>
> Vladimir:
>
> When you run ogrinfo, it has access to any environment variables you 
> have set for the current user, including some relating to oracle. In 
> order for Mapserver to have access to these variables, they need to be 
> set for the web server user. For apache, you can edit httpd.conf to 
> enable and set environment variables.
>
> zak
> --
> Zak James
> Applications and Software Development
> DM Solutions Group Inc.
> http://www.dmsolutions.ca
>
>
> On Feb 16, 2004, at 6:21 PM, Vladimir Guzmán wrote:
>
>> I have the same problem.
>> So I tried with the mapserver's built-in oracle spatial support, but I 
>> have the following error:
>>
>> [MapServer Error]: msOCIConnect() in msOracleSpatialLayerOpen(): 
>> ORA-07217: sltln: environment variable cannot be evaluated.
>>
>> It is an Oracle error, which seems to be related with the environment 
>> variable ORACLE_SID.
>> But it seems to be ok, because the ogrinfo works ok.
>>
>> Any help will be greatly appreciated.
>>
>> Thanks a lot,
>>
>> --------------------
>> Vladimir Guzmán
>>
>> bartvde at xs4all.nl wrote:
>>
>>> Hi list,
>>>
>>> I am trying to connect Mapserver to Oracle through OGR but I am running
>>> into a problem. Error message, output from ogrinfo and excerpt from MAP
>>> file at the bottom of this e-mail. We can connect through the native
>>> Oracle Spatial interface of Mapserver on the same machine.
>>>
>>> Anybody have an idea what could be the problem?
>>>
>>> Thanks in advance,
>>> Bart
>>>
>>> ------
>>> msDrawMap(): Image handling error. Failed to draw layer named 
>>> 'straten'.
>>> msOGRFileOpen(): OGR error. Open failed for OGR connection
>>> `OCI:laura/laura at laura'.  File not found or unsupported format.
>>> ------
>>>
>>> When I connect through ogrinfo there are no problems, this is part of 
>>> the
>>> output generated by ogrinfo:
>>>
>>> ------
>>> INFO: Open of `OCI:laura/laura at laura'
>>> using driver `OCI' successful.
>>>
>>> Layer name: SELECT * from straten where name='Kerkstraat'
>>> Geometry: Unknown (any)
>>> Feature Count: 809
>>> Extent: (19361.400000, 309014.500000) - (276658.600000, 603186.200000)
>>> Layer SRS WKT:
>>> (unknown)
>>> ID: Integer (20.0)
>>> FRC: Integer (9.0)
>>> NAME: String (70.0)
>>> NAMELC: String (3.0)
>>> ROUTENUM: String (50.0)
>>> MI_SYMBOLOGY: String (254.0)
>>> MI_PRINX: Integer (11.0)
>>> OGRFeature(SELECT * from straten where name='Kerkstraat'):0
>>>  ID (Integer) = 2079166603
>>>  FRC (Integer) = 7
>>>  NAME (String) = Kerkstraat
>>>  NAMELC (String) = DUT
>>>  ROUTENUM (String) = (null)
>>>  MI_SYMBOLOGY (String) = (null)
>>>  MI_PRINX (Integer) = 312
>>>  LINESTRING (268161.900 566095.100,268074.900 566072.700)
>>> ------
>>>
>>> This is the relevant part of my MAP file:
>>> ------
>>> NAME "STRATEN"
>>> CONNECTIONTYPE OGR
>>> CONNECTION "OCI:laura/laura at laura"
>>> DATA "SELECT * FROM STRATEN where name='Kerkstraat'"
>>> TYPE LINE
>>> ------
>>>
>>> No errors in the Apache error log.
>>>
>>> _______________________________________________
>>> Mapserver-users mailing list
>>> Mapserver-users at lists.gis.umn.edu
>>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>
>>>
>>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>



--