Milena,<br><br>Could you inspect in the SQL Server Profiler what kind of SQL requests are happening in the subsequent requests?<br><br>Best regards,<br><br>Tamas<br><br><br><br><div class="gmail_quote">2011/1/10 Milena <span dir="ltr"><<a href="mailto:mgebreab@maxgeo.com">mgebreab@maxgeo.com</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><br>
Hi all,<br>
<br>
I have been trying to display a WMS layer from a SQL server database. Now, I<br>
managed successfully to connect to the database and some part of the layer<br>
appeared when Getmap requested but not all the polygons I should be seeing.<br>
The strange thing is every time I refresh the request different parts of the<br>
layer appear. Does anybody know why this might be? Also if I remove the<br>
Class from the Layer, nothing is displayed. Map detail below<br>
<br>
Thanks!<br>
<br>
Milen<br>
<br>
MAP<br>
NAME Spatial<br>
IMAGECOLOR 0 255 255<br>
SIZE 600 800<br>
IMAGETYPE png<br>
PROJECTION<br>
"init=epsg:4326" #latlon on WGS84<br>
END<br>
EXTENT 100.000000 -35.000000 129.000000 -11.000000<br>
# lon/lat extents of WA tenements<br>
WEB<br>
IMAGEPATH "/tmp/ms_tmp/"<br>
IMAGEURL "/ms_tmp/"<br>
METADATA<br>
"map" "C:/ms4w/apps/Spatial/config.map"<br>
"ows_schemas_location" "<a href="http://schemas.opengeospatial.net" target="_blank">http://schemas.opengeospatial.net</a>"<br>
"ows_title" "Sample WMS"<br>
"ows_abstract" "Sample WMS of Spatial"<br>
"ows_keywordlist" "Spatial,WMS,Maxwell"<br>
"ows_onlineresource"<br>
"<a href="http://localhost:8080//spatial?map=C:/ms4w/apps/Spatial/config.map&" target="_blank">http://localhost:8080//spatial?map=C:/ms4w/apps/Spatial/config.map&</a>"<br>
"wms_srs" "EPSG:4326" #latlon<br>
"wms_feature_info_mime_type" "text/plain"<br>
"wms_feature_info_mime_type" "text/html"<br>
"wms_server_version" "1.1.1"<br>
"wms_formatlist" "image/png,image/gif,image/jpeg"<br>
"wms_format" "image/gif"<br>
END #metadata<br>
END #web<br>
LAYER<br>
NAME "tenements"<br>
CONNECTIONTYPE PLUGIN<br>
PLUGIN "C:/ms4w/Apache/specialplugins/msplugin_mssql2008.dll"<br>
<br>
CONNECTION "Server=.\SQL_2008;Database=LeaseCDemo2008GIS;Integrated<br>
Security=true"<br>
<br>
DATA "geom from dbo.WA_Tenements USING UNIQUE ID USING SRID=0"<br>
TYPE POLYGON<br>
<br>
STATUS DEFAULT<br>
<br>
METADATA<br>
"ows_title" "tenements"<br>
END #metadata<br>
PROJECTION<br>
"init=epsg:4326"<br>
END<br>
EXTENT 100.000000 -35.000000 129.0000000 -11.00000000<br>
TOLERANCE 0<br>
MAXSCALE 100000000<br>
CLASS<br>
NAME "tenements"<br>
STYLE<br>
COLOR 255 235 190<br>
OUTLINECOLOR 0 0 0<br>
END #style<br>
<br>
END #class<br>
END #Layer<br>
End #Map<br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/SQL-Server-2008-layer-only-partially-displaying-tp5905621p5905621.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/SQL-Server-2008-layer-only-partially-displaying-tp5905621p5905621.html</a><br>
Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</font></blockquote></div><br><div style="visibility: hidden; left: -5000px; position: absolute; z-index: 9999; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;" id="avg_ls_inline_popup">
</div>