Opened 11 years ago

Closed 8 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.

request: http://192.168.1.100/cgi-bin/mapserv.exe?map=C:\PROJEKTY\wfs.map&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=layer1&bbox=-609472.229946,-1354157.701456,-154598.815421,-1102498.234608

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)

ms_sql_log.log (3.7 KB) - added by imincik 11 years ago.
Log File

Download all attachments as: .zip

Change History (6)

Changed 11 years ago by imincik

Attachment: ms_sql_log.log added

Log File

comment:1 Changed 11 years ago by tamas

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 Changed 11 years ago by tamas

Component: MapServer C LibraryInput - Native MS SQL Server Support

comment:3 Changed 9 years ago by tamas

Owner: changed from asefa to tamas

comment:4 Changed 9 years ago by tamas

Milestone: 5.6.2 release
Version: 5.25.6

This should be re-tested, since there have been a couple of changes in the driver recently.

comment:5 Changed 8 years ago by tamas

Resolution: fixed
Status: newclosed

Closing the ticket, no feedback has received.

Note: See TracTickets for help on using tickets.