[mapserver-users] Mapserver MS SQL Server Spacial

[Donald Kerr]

Is it possible to connect to MS SQL Server Spacial in the same was as
PostGis?

CONNECTIONTYPE postgis
CONNECTION "user=postgres dbname=MasterMap host=localhost"
DATA "geom FROM topographicline USING UNIQUE toid"

Or

CONNECTIONTYPE postgis
CONNECTION "user=postgres dbname=MasterMap host=localhost"
DATA "geom FROM (SELECT toid, featurecode, textstring, orientation/10 AS
orientation, fontnumber, anchorposition, textstyle, geom FROM
cartographictext) AS foo USING UNIQUE toid"

If not, is there an alternative method without altering the database?

Many thanks.

Regards,

Donald