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
