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-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Kiks Sent: Wednesday, February 24, 2010 3:48 PM To: mapserver-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
