[mapserver-users] Mapserver MS SQL Server Spacial

Donald Kerr donald.kerr at dkerr.co.uk
Thu Jan 8 08:33:46 EST 2009


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



More information about the mapserver-users mailing list