[mapserver-users] Re: Reg:About Native Microsoft SQL Server 2008 Driver for MapServer

[Morten Sickel]

Anybody knows if this plugin exists in osgeo4w? Or if I can download ms4w and "steal" the plugin from there? At least I have not managed to find it within my recently updated osgeo4w installation

Morten Sickel
Norwegian Radiation Protection Authority
 

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Kiks
Sent: Wednesday, February 24, 2010 3:48 PM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] Re: Reg:About Native Microsoft SQL Server 2008 Driver for MapServer


A read-only, native MapServer driver that connects to Microsoft SQL Server 2008's spatial capabilities is available in MS4W as of version 2.3.0.

Steps to Enable SQL Server 2008 Support in MS4W's MapServer

The plugin exists in /ms4w/Apache/specialplugins/msplugin_mssql2008.dll

Modify your SQL Server 2008 layer in your mapfile to use the CONNECTIONTYPE PLUGIN parameter and point to the appropriate plugin using the PLUGIN parameter. Use the CONNECTION parameter to specify the required connection parameters to access SQL Server, and use the DATA parameter to specify the table that holds the spatial information:

LAYER
  ...
  CONNECTIONTYPE PLUGIN
  PLUGIN "C:/ms4w/Apache/specialplugins/msplugin_mssql2008.dll"
  CONNECTION "server=mysqlserver2008.com;uid=dbusername;
               pwd=dbpassword;database=Roads Database;
                 Integrated Security=false"
  DATA "the_geom from roads"
  TYPE LINE
  STATUS ON
  CLASS
     ...
  END
END
Test your layer, possibly by using the shp2img commandline utility with the '-all_debug 5' switch

The associated RFC document with the original notes on this support is RFC
38
--
View this message in context: http://n2.nabble.com/Reg-About-Native-Microsoft-SQL-Server-2008-Driver-for-MapServer-tp1971580p4626221.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users