I think one of the key problems will be using the postgis connector to connect to MSSQL...
----- Original Message ---- > From: Donald Kerr <[email protected]> > To: [email protected] > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
