[Mapserver-users] Mapserver - Oracle through OGR

[bartvde at xs4all.nl]

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.