[mapserver-users] Mapserver MS SQL Server Spacial

Neil.Young Neil.Young at Freenet.de
Fri Jan 9 03:32:27 EST 2009


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>

pcreso at pcreso.com schrieb:
>
> --- 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
>>     
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>   


More information about the mapserver-users mailing list