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

[Kiks]

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.