[Mapserver-users] connection in mapfile to Oracle spatial is not used

[Patricia Witte]

> Could you show us the mapfile code for your Oracle layer.

# Oracle Spatial
#################
LAYER
NAME "Kataster"
STATUS ON
CONNECTIONTYPE oraclespatial
CONNECTION "gbd/gbd at lbddb9"

DATA "AL001_GEOM FROM AL001_001_0000_00_GF_TB USING SRID 82027"
# FILTER "AL001_FS_GEMARKUNG = 3641"
TYPE POLYGON
   CLASS
      COLOR 255 255 255
      OUTLINECOLOR  0 0 0
   END
END

>
> Do you have the win binary compiled for Oracle?

yes, btw it is mapserver 4.0

> Hi,
> I have successfully run MapServer under IIS 5.0 with some shapefile. With a
> spatial layer i get the error: msDrawMap(): unable to draw layer.
>
> With some onlog-trigger in my database I've shown
> that the connection in the mapfile is not used, there is no logon performed.
> I have tried everything I've found in the archive (oci.dll, path,
> ORACLE_HOME). Connect through sqlplus is possible. Has anyone solved this
> before? Thanks, Patricia
>