Compiling with OGR version supporting SQL server connection

Thomas Rokkjaer thomas.rokkjaer at GMAIL.COM
Wed Jul 11 12:11:11 PDT 2007


I have followed the guidelines for setting up a virtual spatial data connection 
at 
http://mapserver.gis.umn.edu/docs/reference/vector_data/VirtualSpatialData, 
installed FWTools 1.3.4, tested the connection via ogrinfo successfully, tested 
the mapfile (specific layer attached) with the shp2img tool successfully, but I 
am having problems with displaying this newly generated layer in my map 
window.
At http://mapserver.gis.umn.edu/docs/howto/ogrmysql I found a how-to for 
OGR connection to MySQL, where it is stated the following 
prerequisite "MapServer compiled with OGR version supporting this 
functinality". How is it possible to compile my current MapServer to support 
OGR for SQL server or should it already work with the current settings?

mapserv -v
MapServer version 4.99 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG 
OUTPUT=WBMP OUTPUT=SVG
SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER 
SUPPORTS=WMS_CLIENT SUPPORTS
=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER 
SUPPORTS=FASTCGI SUPPORTS=TH
READS INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE 
DEBUG=MSDEBUG

Thanks!
BR
Thomas 
-------------- next part --------------
LAYER
        CONNECTION "<OGRVRTDataSource>
        <OGRVRTLayer  name='DVHenvendelse'>
        <SrcDataSource>ODBC:test/test at DVHenvendelse</SrcDataSource>
        <SrcLayer>DVHenvendelse</SrcLayer>
        <GeometryField encoding='PointFromColumns' x='XKoordinat' y='YKoordinat'/>
        <GeometryType>wkbPoint</GeometryType>
        </OGRVRTLayer>
        </OGRVRTDataSource>"
        CONNECTIONTYPE OGR
        DATA "DVHenvendelse"
        METADATA
                "wms_srs"   "EPSG:25832"
                "wms_title"   "DVHenvendelse"
        END
        NAME "DVHenvendelse"
        SIZEUNITS PIXELS
        STATUS ON
        TOLERANCE 0
        TOLERANCEUNITS PIXELS
        TYPE POINT
        UNITS METERS
        CLASS
                STYLE
                        COLOR 255 0 255
                        MAXSIZE 100
                        MINSIZE 1
                        SIZE 10
                        SYMBOL "punkt"
                END
        END

	STYLEITEM "AUTO"
	HEADER 'header'
   	TEMPLATE 'template.html'
   	FOOTER 'footer.html'
END



More information about the MapServer-users mailing list