It is supported. See this sample:
http://johanneskebeck.spaces.live.com/blog/cns!42E1F70205EC8A96!7718.entry?_c=BlogPart
<http://johanneskebeck.spaces.live.com/blog/cns%2142E1F70205EC8A96%217718.entry?_c=BlogPart>
[email protected] schrieb:
--- On Fri, 1/9/09, Richard Greenwood <[email protected]> wrote:
From: Richard Greenwood <[email protected]>
Subject: Re: [mapserver-users] Mapserver MS SQL Server Spacial
To: "Donald Kerr" <[email protected]>
Cc: [email protected]
Date: Friday, January 9, 2009, 4:56 PM
On Thu, Jan 8, 2009 at 6:33 AM, Donald Kerr
<[email protected]> 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
[email protected]
www.greenwoodmap.com
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
