[mapserver-users] Mapserver MS SQL Server Spacial

Dan Little danlittle at yahoo.com
Thu Jan 8 07:11:11 PST 2009


I think one of the key problems will be using the postgis connector to connect to MSSQL...



----- Original Message ----
> From: Donald Kerr <donald.kerr at dkerr.co.uk>
> To: mapserver-users at lists.osgeo.org
> Sent: Thursday, January 8, 2009 7:33:46 AM
> Subject: [mapserver-users] Mapserver MS SQL Server Spacial
> 
> 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
> 
> _______________________________________________
> 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