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

Patricia Witte Patricia.Witte@isb-mz.de
Mon, 19 Jan 2004 09:27:26 +0100


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

# Oracle Spatial
#################
LAYER
NAME "Kataster"
STATUS ON
CONNECTIONTYPE oraclespatial
CONNECTION "gbd/gbd@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
>

_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users