You can use the mssql2008 plugin on Windows platforms to access MSSQL2008 spatial, the latest fixes have been incorporated in MapServer version 5.2.1 (2008-12-01)<br><br>Best regards,<br><br>Tamas<br><br><br><br><div class="gmail_quote">
2009/1/8 Donald Kerr <span dir="ltr"><<a href="mailto:donald.kerr@dkerr.co.uk">donald.kerr@dkerr.co.uk</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;">
Is it possible to connect to MS SQL Server Spacial in the same was as<br>
PostGis?<br>
<br>
CONNECTIONTYPE postgis<br>
CONNECTION "user=postgres dbname=MasterMap host=localhost"<br>
DATA "geom FROM topographicline USING UNIQUE toid"<br>
<br>
Or<br>
<br>
CONNECTIONTYPE postgis<br>
CONNECTION "user=postgres dbname=MasterMap host=localhost"<br>
DATA "geom FROM (SELECT toid, featurecode, textstring, orientation/10 AS<br>
orientation, fontnumber, anchorposition, textstyle, geom FROM<br>
cartographictext) AS foo USING UNIQUE toid"<br>
<br>
If not, is there an alternative method without altering the database?<br>
<br>
Many thanks.<br>
<br>
Regards,<br>
<br>
Donald<br>
<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>
</blockquote></div><br>