[Mapserver-users] SDE-support-problem

Steve Lime steve.lime at dnr.state.mn.us
Wed May 14 15:27:11 EDT 2003


MapLab uses PHP/MapScript, not mapserv.exe. Was that recompiled as well?

>>> Jörn Witte <jwitte at gmx.at> 05/06/03 08:29AM >>>
Hi,
 
I've got a question concerning ArcSDE 8.1 and Mapserver 3.6.5. 
I've compiled the Mapserver on XP with MSVC++ successfully..
After this, i have move the mapserv.exe into the cgi-bin-folder (Apache)
and
configured a new map-file on MapLab.
Now, i starts the MapBrowser and gets the following message: 'MapServer
Error in msSDELayerOpen(): SDE support is not available.'  
Does anyone have an idea of what is going wrong?
 
Thanks,
Jörn Witte
 
 
My configuration is:
 
C:\Programme\Apache Group\Apache2\cgi-bin>mapserv -v
MapServer version 3.6.5 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
SUPPORTS=PROJ SUPPORTS=TTF SUPPORTS=WMS_SERVER INPUT=TIFF INPUT=SDE
INPUT=OGR INPUT=SHAPEFILE
 
 
My Makefile is:
 
 
#
# makefile.vc - Main MapServer makefile for MSVC++
#
# This VC++ makefile will build MAPSERVER.LIB, MAPSERV.EXE, and the
other
# MapServer command-line programs.
#
# To use the makefile:
#  - Open a DOS prompt window
#  - Run the VCVARS32.BAT script to initialize the VC++ environment
variables
#  - Start the build with:  nmake /f makefile.vc
#
# $Id: Makefile.vc,v 1.21.2.1 2002/08/01 14:46:45 assefa Exp $
#
 
OPTFLAGS =  /nologo /Zi /W3 /DDEBUG /DWIN32
#OPTFLAGS = /nologo /Zi 
BASE_CFLAGS =     $(OPTFLAGS) 
LDFLAGS =   /NODEFAULTLIB:libcd /DEBUG
 
CC=     cl
LINK=   link /debug
 
#
# If you want to ignore missing datafile errors uncomment the following
# line. This is especially useful with large tiled datasets that may not
# have complete data for each tile.
#
IGNORE_MISSING_DATA=-DIGNORE_MISSING_DATA
 
#
# Apparently these aren't as commonplace as I'd hoped. Edit the
# following line to reflect the missing functions on your platform.
#
#STRINGS=-DNEED_STRCASECMP -DNEED_STRNCASECMP -DNEED_STRDUP
STRINGS=-DNEED_STRCASECMP -DNEED_STRNCASECMP
 
# Proj.4 distribution (cartographic projection routines). Not required
for normal use. (EXPERIMENTAL)
PROJ_LIB=../proj-4.4.3/src/proj.lib
PROJ_INC=-I../proj-4.4.3/src
PROJ=-DUSE_PROJ -DUSE_PROJ_API_H
 
#Use this flag to compile with WMS support
WMS=-DUSE_WMS
 
#Use this flag to compile with WMS Client support
#you need the libwww from http://www.w3.org/Library/.
#WMSCLIENT= -DUSE_WMS_LYR
 
#WWWLIB_INC=-I../libwww/library/src -I../libwww/modules/expat/xmlparse
#WWWLIB_LIB=../libwww/bin/wwwcore.lib ../libwww/bin/wwwapp.lib
../libwww/bin/wwwinit.lib ../libwww/bin/wwwutils.lib
 
# GD distribution (graphics library GIF and/or PNG support). (REQUIRED)
#
#   - Version 1.2 is included and writes LZW GIF (-DUSE_GD_GIF
-DUSE_GD_SWAP_XY).
#   - Versions 1.3 to 1.5 write non-LZW GIF (-DUSE_GD_GIF).
#   - Versions 1.6 and greater write PNG (-DUSE_GD_PNG). Add -lpng -lz
to GD_LIB line.
#   - Versions 1.8 (or was it 1.7?) also supports JPEG and WBMP
(-DUSE_GD_JPEG -DUSE_GD_WBMP)
#
# The following lines will compile GD 1.2:
#GDFONT_OBJ=      gd-1.2/gdfontt.obj gd-1.2/gdfonts.obj
gd-1.2/gdfontmb.obj \
#           gd-1.2/gdfontl.obj gd-1.2/gdfontg.obj
#GD_INC=    -I./gd-1.2
#GD_LIB=    gd-1.2/gd.lib
#GD= -DUSE_GD_GIF -DUSE_GD_SWAP_XY
#MAKE_GD=gd
 
# A patched version of GD that supports GIF, JPEG, PNG and WBMP can be 
# downloaded from http://www.rime.com.au/gd/.
# The following defns will include the patched GD 1.8.4 with TTF:
GDFONT_OBJ=
GD_INC=     -I../gd-1.8.4
GD_LIB=     ../gd-1.8.4/gd.lib \
         ../jpeg-6b/libjpeg.lib \
        ../lpng120/projects/msvc/win32/libpng/lib_dbg/libpng.lib \
      ../zlib/zlib.lib  ../freetype-2.1.4/objs/freetype214ST_D.lib
GD=     -DUSE_GD_GIF -DUSE_GD_PNG -DUSE_GD_JPEG -DUSE_GD_WBMP
-DUSE_GD_TTF \
      -DUSE_GD_TTF -DGD_HAS_GDIMAGEGIFPTR
MAKE_GD=gd
 
#        ../jpeg-6b/libjpeg.lib \
#        ../libpng-1.0.8/libpng.lib \
#     ../zlib/zlibstat.lib  ../freetype/lib/freetype.lib
#GD=     -DUSE_GD_GIF -DUSE_GD_PNG -DUSE_GD_JPEG -DUSE_GD_WBMP
-DUSE_GD_TTF \
#     -DUSE_GD_TTF -DGD_HAS_GDIMAGEGIFPTR
#MAKE_GD=gd
 
# TIFF distribution (raster support for TIFF and GEOTIFF
imagery).(RECOMMENDED)
TIFF_INC=-I../tiff-v3.5.5/libtiff
TIFF_LIB=../tiff-v3.5.5/libtiff/libtiff.lib
TIFF=-DUSE_TIFF
 
# JPEG distribution (raster support for grayscale JPEG images, INPUT
ONLY).
#JPEG_INC=
#JPEG_LIB=-ljpeg
#JPEG=-DUSE_JPEG
 
# EPPL7 Support (this activates ERDAS as well) Included in the
distribution. Probably the best raster alternative if
# you've got EPPL7 laying around. See http://www.lmic.state.mn.us/ for
more information. (RECOMMENDED)
#EPPL=-DUSE_EPPL
#EPPL_OBJ=epplib.obj
 
# OGR Support OGC Simple Feature inspired interface for vector
# formats.  See http://gdal.velocet.ca/projects/opengis/ 
GDAL_DIR= ..\gdal-1.1.8
OGR=-DUSE_OGR
OGR_LIB =  $(GDAL_DIR)/gdal.lib
$(GDAL_DIR)/ogr/ogrsf_frmts/ogrsf_frmts.lib
$(GDAL_DIR)/ogr/ogrsf_frmts/ogrsf_frmts_sup.lib $(GDAL_DIR)/ogr/ogr.lib
$(GDAL_DIR)/ogr/../port/cpl.lib
OGR_INC = -I$(GDAL_DIR)/ogr/ogrsf_frmts -I$(GDAL_DIR)/ogr
-I$(GDAL_DIR)/ogr/../port -I$(GDAL_DIR)/core
 
#GDAL=-DUSE_GDAL
 
# ESRI SDE support.
SDE_OPT=-DUSE_SDE -DWIN32
SDE_INC= -I ../arcsde/include -I ../arcsde/bin
SDE_LIB=../arcsde/lib/sde81.lib ../arcsde/lib/sg81.lib
../arcsde/lib/pe81.lib
 
#
# UofMN GIS/Image Processing Extension (very experimental)
#
#EGIS=-DUSE_EGIS
 
#ERR_OBJ=./errLog/errLog.o
#ERR_INC=-I./errLog
#ERR_LIB=-L./errLog -lerrLog
 
#IMGGEN_OBJ=./imgSrc/imgLib.o
#IMGGEN_INC=-I./imgSrc
#IMGGEN_LIB=-L./imgSrc -limgGEN
 
#ECWDIR= C:\ProgFile\ECW_SDK
#ECW_LIB=$(ECWDIR)\lib\NCSEcw.lib $(ECWDIR)\lib\NCSEcwC.lib \
#        $(ECWDIR)\lib\NCSUtil.lib
#
# VC++ does not include the REGEX library... so we must provide our one.
# The following definitions will try to build GNU regex-0.12 located in
the
# regex-0.12 sub-directory.
# If it was not included in the source distribution, then you can get it
from:
#    ftp://ftp.gnu.org/pub/gnu/regex/regex-0.12.tar.gz 
#
#REGEX_OBJ=..\regex-0.12\regex.obj
#REGEX_INC=-I ..\regex-0.12
 
#
# IMPORTANT NOTE ABOUT REGEX FOR PHP_MAPSCRIPT USERS:
#
# If you want to compile the PHP_MAPSCRIPT module, then you have to make
# MapServer uses the same version of the REGEX library that PHP was 
# compiled with:
#
PHP_REGEX=..\php-4.3.1\regex
#PHP_REGEX=..\php-3.0.14\regex
#PHP_REGEX=..\php-4.0.6\regex
#PHP_REGEX=..\php-4.1.2\regex
#PHP_REGEX=..\php-4.2.1\regex
#PHP_REGEX=..\php-4.2.2\regex
REGEX_OBJ=$(PHP_REGEX)\regcomp.obj $(PHP_REGEX)\regerror.obj \
          $(PHP_REGEX)\regexec.obj $(PHP_REGEX)\regfree.obj
REGEX_INC=-I$(PHP_REGEX) -DPHP_NO_ALIASES
 
#
# REGEX needs some special flags... here they are for VC++ 6.0
#
#REGEX_OPT=-DHAVE_STRING_H -DREGEX_MALLOC
=loaded from http://www.rim 
#
# --- You shouldn't have to edit anything else. ---
#
 
#
# Main MapServer library.
#
MS_LIB  =   mapserver.lib
MS_OBJS =   mapbits.obj maphash.obj mapshape.obj mapxbase.obj \
            mapparser.obj maplexer.obj mapindex.obj maptree.obj \
            mapsearch.obj mapstring.obj mapsymbol.obj mapfile.obj \
            maplegend.obj maputil.obj mapscale.obj mapquery.obj \
            maplabel.obj maperror.obj mapprimitive.obj mapproject.obj\
            mapraster.obj cgiutil.obj mapsde.obj mapogr.obj \
            maptemplate.obj mappostgis.obj maplayer.obj mapresample.obj
\
            mapwms.obj mapwmslayer.obj mapgml.obj maporaclespatial.obj \
            mapprojhack.obj \
            $(EPPL_OBJ) $(REGEX_OBJ)
 
MS_HDRS =   map.h mapfile.h
 
MS_EXE =    mapserv.exe \
                shp2img.exe legend.exe  \
            shptree.exe scalebar.exe sortshp.exe tile4ms.exe
 
#
#
#
LIBS  =     $(MS_LIB) $(GD_LIB) $(TIFF_LIB) $(JPEG_LIB) \
            $(PROJ_LIB) $(ERR_LIB) $(IMGGEN_LIB) $(OGR_LIB) \
            $(WWWLIB_LIB) $(ECW_LIB) $(SDE_LIB) 
 
INCLUDES =  $(GD_INC) $(TIFF_INC) $(JPEG_INC) \
            $(PROJ_INC) $(ERR_INC) $(IMGGEN_INC) $(REGEX_INC) $(OGR_INC)
\
            $(WWWLIB_INC) $(SDE_INC)
 
CFLAGS =    $(BASE_CFLAGS) $(INCLUDES) $(REGEX_OPT) $(STRINGS) \
            $(EPPL) $(PROJ) $(TIFF) $(JPEG) $(GD) $(OGR) $(WMS)
$(WMSCLIENT) \
            $(IGNORE_MISSING_DATA) $(GDAL) -DFEATURE_INFO_HTML
$(SDE_OPT)
 
#           $(EPPL) $(PROJ) $(TIFF) $(JPEG) $(GD) $(OGR) $(WMS)
$(WMSCLIENT) \
#                $(IGNORE_MISSING_DATA) $(GDAL) -DFEATURE_INFO_HTML
 
default:    all
 
all:        $(MS_LIB) $(MS_EXE)
 
$(MS_OBJS): $(MS_HDRS)
 
$(MS_LIB):  $(MS_OBJS)
      copy $(GDAL_DIR)\gdal11.pdb .
      lib /out:$(MS_LIB) $(MS_OBJS)
 
$(MS_EXE):  $(LIBS)
 
gd::
      cd gd-1.8.4
      nmake /f makefile.nt gd.lib OPTFLAGS="$(OPTFLAGS)"
      cd ..
 
.c.obj:     
      $(CC) $(CFLAGS) /c $*.c /Fo$*.obj
 
.cpp.obj:   
      $(CC) $(CFLAGS) /c $*.cpp /Fo$*.obj
 
.c.exe:
      $(CC) $(CFLAGS) /c $*.c /Fo$*.obj
      $(LINK) $(LDFLAGS) $*.obj $(LIBS)
 
.cpp.exe:
      $(CC) $(CFLAGS) /c $*.cpp /Fo$*.obj
      $(LINK) $(LDFLAGS) $*.obj $(LIBS)
 
 
clean:
      del *.obj
      del $(REGEX_OBJ)
      del $(MS_LIB)
      del $(MS_EXE)
      del *.pdb
      del *.exp
      del *.ilk
#     cd gd-1.2
#     nmake -f makefile.nt clean
#     cd ..
 
 
 
my mapfile is:
 
 
      MAP
  NAME "Bremen"
  STATUS ON
  EXTENT 3.46e+006 5.87198e+006 3.50161e+006 5.90314e+006 
  SIZE 400 300 
  IMAGECOLOR 255 255 255
  TRANSPARENT OFF
  UNITS METERS
  INTERLACE ON
  IMAGETYPE PNG
  IMAGEQUALITY 75
  WEB
    MINSCALE 20000
    MAXSCALE 5e+007
    IMAGEPATH "c:/windows/temp/"
    IMAGEURL "/ms_tmp/"
  END
  QUERYMAP
    STATUS OFF
    SIZE -1 -1 
    COLOR 255 255 0
    STYLE HILITE
  END
  LEGEND
    STATUS OFF
    IMAGECOLOR 255 255 255
    TRANSPARENT FALSE
    INTERLACE TRUE
    POSITION LL
    KEYSIZE 20 10 
    KEYSPACING 5 5 
    TEMPLATE "C:/Programme/Apache
Group/Apache2/htdocs/maplab-2.0rc5/htdocs/mapbrowser/legend_template.htm
l"
    LABEL
      TYPE BITMAP
      SIZE MEDIUM
      OFFSET 0 0 
      BUFFER 0
      MINDISTANCE -1
      MINFEATURESIZE -1
      COLOR 255 255 255
      PARTIA=loaded from http://www.rimLS TRUE
      FORCE FALSE
    END
  END
  SCALEBAR
    STATUS ON
    COLOR 255 255 255
    OUTLINECOLOR 0 0 0
    BACKGROUNDCOLOR 0 0 0
    IMAGECOLOR 255 255 255
    TRANSPARENT FALSE
    UNITS KILOMETERS
    INTERVALS 5
    SIZE 150 5 
    STYLE 0
    POSITION LL
    INTERLACE TRUE
    LABEL
      TYPE BITMAP
      SIZE SMALL
      OFFSET 0 0 
      BUFFER 0
      MINDISTANCE -1
      MINFEATURESIZE -1
      COLOR 0 0 0
      PARTIALS TRUE
      FORCE FALSE
    END
  END
  LAYER
    NAME "Verwaltung"
    STATUS ON
    DATA "BREMEN_STADTTEILE,shape"
    TYPE POLYGON
    CONNECTIONTYPE SDE
    CONNECTION "kbs2,esri_sde,sde,sde,EsgibtReis"
    UNITS METERS
    SIZEUNITS PIXELS
    TOLERANCE 3
    TOLERANCEUNITS PIXELS
    TEMPLATE "ttt.html"
    CLASS
      NAME "Verwaltungseinheiten"
      SYMBOL 0
      COLOR 90 200 90
      SIZE 1
      MINSIZE 1
      MAXSIZE 100
    END
  END
END




More information about the mapserver-users mailing list