geospatial team at nomad labs
Mapserver + MS-SQL Server
27Mar2006 Filed under: Mapserver Author: shoaibWell eventually someone was gonna ask this. Can you connect to MS-SQL using Mapserver? Of course thanks to GDAL/OGR anything is possible. OGR’s Virtual Spatial Data can be used to connect to SQL Server database. http://www.gdal.org/ogr/drv_vrt.html
One can connect via OGR ODBC driver directly by creating a view with an additional WKT column from your x, y fields and add this view to the GEOMETRY_COLUMNS table in your database http://www.gdal.org/ogr/drv_odbc.html
About GeoLabs
GeoLabs is the Spatial team at Nomad Labs. We love all things spatial and particularly like the idea of spatial analysis on the geoweb. We also tend to use a lot of open source GIS in our work. Yey! to the open source. Other than that we love dynamic languages, open RESTful API's and beautiful code and thoughtfully designed software. All things that we try to adhere to in our work.
Leave a reply