[mapserver-users] Mapserver MS SQL Server Spacial

[Richard Greenwood]

On Thu, Jan 8, 2009 at 6:33 AM, Donald Kerr <donald.kerr at dkerr.co.uk> wrote:
> Is it possible to connect to MS SQL Server Spacial in the same was as
> PostGis?


I do not think that Microsoft SQL Server is officially supported in
MapServer yet, however you can get it working using binaries at:
  http://vbkto.dyndns.org:1280/tests/release-1400-20081013.zip

read the thread at:
  http://mail.google.com/mail/?ui=2&ik=a8159b4950&view=cv&fs=1&tf=1&ver=a9SCC6X1Wbg&am=x_k6ocT3aCEJBf1qUObqFA&q=release-1400-20081013.zip&search=query&th=11cf6af5d8018b96&qt=release.1.1400.1.20081013.1.zip.1

The relevant line in the layer object in the MapFile:
   CONNECTIONTYPE PLUGIN
   PLUGIN "msplugin_mssql2008.dll"
   CONNECTION "server=.\SQLEXPRRESS; database=sc_lands; Integrated
Security=true"
   DATA "geom FROM ownership WITH (INDEX(geom_sidx)) USING SRID=0
USING UNIQUE id"

HTH,
Rich

-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com