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