[mapserver-users] Mapserver MS SQL Server Spacial

[pcreso at pcreso.com]

--- On Fri, 1/9/09, Richard Greenwood <richard.greenwood at gmail.com> wrote:

> From: Richard Greenwood <richard.greenwood at gmail.com>
> Subject: Re: [mapserver-users] Mapserver MS SQL Server Spacial
> To: "Donald Kerr" <donald.kerr at dkerr.co.uk>
> Cc: mapserver-users at lists.osgeo.org
> Date: Friday, January 9, 2009, 4:56 PM
> 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
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users