[Mapserver-users] SDE-support-problem

jwitte at informatik.uni-bremen.de jwitte at informatik.uni-bremen.de
Tue May 6 10:09:01 EDT 2003


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/ww
winit.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

 

#

# --- 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.html"

    LABEL

      TYPE BITMAP

      SIZE MEDIUM

      OFFSET 0 0 

      BUFFER 0

      MINDISTANCE -1

      MINFEATURESIZE -1

      COLOR 255 255 255

      PARTIALS 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