<br><br><div style="visibility: hidden; display: inline;" id="avg_ls_inline_popup"></div><style type="text/css">#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 13px;}</style><div class="gmail_quote">
2010/7/24 geographika <span dir="ltr"><<a href="mailto:geographika@gmail.com">geographika@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Has anyone successfully created a WFS service using the SQL Server 2008 plug in?<br>
<br>
I followed the steps at <a href="http://mapserver.org/ogc/wfs_server.html" target="_blank">http://mapserver.org/ogc/wfs_server.html</a>, and get no errors when running a SERVICE=WFS&VERSION=1.0.0&REQUEST=getcapabilities request.<br>
<br>
However when trying to retrieve the features using a feature request (&SERVICE=WFS&VERSION=1.0.0&REQUEST=getfeature&TYPENAME=RoadsWFS) I don't get any GML. There are no errors in the MapServer log file. I don't believe this GET request requires a proxy and I get the same result on the server itself.<br>
<br>
I ran SQL Server profiler and the results and geometry are being correctly queried from the database. A shortened version of the SQL is below (several attributes removed):<br>
<br>
SELECT convert(varchar(max), RoadID),GEOM.STAsBinary(),convert(varchar(20), ROADID) from RoadNetwork2 WHERE GEOM.STIntersects(Geometry::STGeomFromText('POLYGON((-710069 7038976,-683731 7038976,-683731 7059350,-710069 7059350,-710069 7038976))',3785)) = 1<br>
<br>
I think there may be an issue due to none of the columns having names.<br></blockquote></div><br><br>Hi<br><br>I've just tried with the recent version of the mssql2008 driver and it works for me. Which mapserver version are you testing with?<br>
I would recommend to do a test with one of the daily build packages from: <a href="http://vbkto.dyndns.org/sdk/">http://vbkto.dyndns.org/sdk/</a><br><br>If your problem still persists, feel free to open a ticket, attach your mapfile, sample requests and test data (ie. a shapefile) to be uploaded to the mssql2008 server.<br>
<br>Best regards,<br><br>Tamas<br><br><br>