<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 24/07/2010 23:25, Tamas Szekeres wrote:
<blockquote
cite="mid:AANLkTinc4JkWV1Gv=9HKLOs1_2zdMbVPSCabuKJa3ogM@mail.gmail.com"
type="cite"><br>
<br>
<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
moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
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>
</blockquote>
Thanks Tamas for your reply. <br>
I am currently using a 5.6.1 build (x64) of MapServer taken from
your site - thanks also for this vital site. <br>
I will start to try and recreate the issue from the simplest data
and map file as possible, but I just wanted to check that the issue
is not due to the SQL statement not having alias names.<br>
When you run your requests do the columns have names? When I run the
SQL in the management studio all fields are titled (No Column Name).
However the correct data and geometry is returned. <br>
In my METADATA for the layer I've tried using<br>
<br>
"gml_include_items" "all"<br>
and also setting alias names for fields e.g.<br>
"gml_RoadID_alias" "OID" but with no luck. <br>
<br>
Regards,<br>
<br>
Seth<br>
<br>
<a href="http://geographika.co.uk">http://geographika.co.uk</a><br>
<br>
<br>
</body>
</html>