Opened 15 years ago
Closed 13 years ago
#2786 closed defect (fixed)
msplugin_mssql2008.dll not working with WFS requests
Reported by: | imincik | Owned by: | tamas |
---|---|---|---|
Priority: | normal | Milestone: | 5.6.2 release |
Component: | Input - Native MS SQL Server Support | Version: | 5.6 |
Severity: | normal | Keywords: | ms sql, msplugin_mssql2008.dll |
Cc: |
Description
I have installed latest MS4W 2.3.0 which includes msplugin_mssql2008.dll on Win XP. I am using MS SQL Express 2008. WMS requests are working. shp2img is working too. WFS is NOT working.
response: <wfs:FeatureCollection xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd http://mapserver.gis.umn.edu/mapserver http://127.0.0.1/cgi-bin/mapserv.exe?SERVICE=WFS&VERSION=1.0.0&REQUEST=DescribeFeatureType&TYPENAME=layer1&OUTPUTFORMAT=XMLSCHEMA"> <gml:boundedBy>
<gml:Box srsName="EPSG:2065">
<gml:coordinates>
-591444.125124,-1334766.000059 -165438.296751,-1132701.999941
</gml:coordinates>
</gml:Box>
</gml:boundedBy> <!--
WARNING: FeatureId item 'CISLOKU' not found in typename 'layer1'.
--> </wfs:FeatureCollection>
mapfile: LAYER
NAME 'layer1'
DEBUG 5
TYPE POLYGON
CONNECTIONTYPE PLUGIN PLUGIN "C:\ms4w\Apache\specialplugins\msplugin_mssql2008.dll"
CONNECTION "server=QQ-7A8B4CA041A3\SQLEXPRESS;uid=ivo;pwd=qq;database=testgis;Integrated Security=false" DATA "geom from (select * from dbo.ku) as ku USING UNIQUE CISLOKU"
STATUS ON PROJECTION
"init=epsg:2065"
END METADATA
"DESCRIPTION" "test" 'wms_title' 'test'
"wms_format" "image/png"
"wms_srs" "epsg:2065" "WMS_FEATURE_INFO_MIME_TYPE" "text/html" "wms_connectiontimeout" "60" "wms_extent" "-609472.229946 -1354157.701456 -154598.815421 -1102498.234608" "wms_include_items" "all" # DOLEZITE : nastavuje ktore atributy ma WMS GetFeatureInfo zobrazit "wfs_title" "test" ## REQUIRED "gml_featureid" "CISLOKU" ## REQUIRED "wfs_extent" "-609472 -1354157 -154598 -1102498" "gml_include_items" "all" ## Optional (serves all attributes for layer) "wfs_srs" "epsg:2065"
END
DUMP TRUE
CLASS
NAME "test" STYLE
SYMBOL 0 OUTLINECOLOR 239 110 115 COLOR 204 204 204
END
END
END
Ivan
Attachments (1)
Change History (6)
by , 15 years ago
Attachment: | ms_sql_log.log added |
---|
comment:1 by , 15 years ago
According to the logfile this problem might be related to #2791 which was now fixed in the trunk and branch 5-2. Would you make a test with the recent version?
comment:2 by , 15 years ago
Component: | MapServer C Library → Input - Native MS SQL Server Support |
---|
comment:3 by , 14 years ago
Owner: | changed from | to
---|
comment:4 by , 14 years ago
Milestone: | → 5.6.2 release |
---|---|
Version: | 5.2 → 5.6 |
This should be re-tested, since there have been a couple of changes in the driver recently.
comment:5 by , 13 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Closing the ticket, no feedback has received.
Log File