I need to create some layers in my map from a Microsoft SQL 2008 database. I am using Openlayers and Mapserver. The Mapserver instance is running on SUSE linux, so the Mapserver documentation on MSSQL that discusses the plugin for Windows is not very helpful.
I know it is possible because I have in the past gotten it to work, however I scrapped that project in favor for something else. I now have a need for it once again and have been unsuccessful finding any clear and concise examples.
Any help or direction would be greatly appreciated.
[GIS] How to get data from MS SQL Server 2008 into Mapserver
linuxmapserversql server
Related Question
- [GIS] How to load spatial data into ArcGIS Javascript API application from SQL Server 2008
- [GIS] Insert Geography data into SQL Server 2008
- SQL Server – How to Import Shapefile Using Only SQL Scripts
- Convert Spatial Geographic Data from SQL Server 2008 to JSON
- [GIS] MapServer connection to SQL Server 2008
- [GIS] Polygons to Lines SQL Server 2008/2012
Best Answer
To confirm the Windows plugin you are referring to is the MSSQL Plugin at http://mapserver.org/input/vector/mssql.html?
Does the OGR driver work on Linux when connecting to Linux? http://www.gdal.org/ogr/drv_mssqlspatial.html
It makes reference to a different ODBC driver that can be used in the connection string:
FreeTDS is
So maybe this driver can also work with the MapServer SQL Server 2008 plugin? If not you could try creating an OGR Layer.