You need to log in before you can comment on or make changes to this bug.
Maul, Andreas-Alexander wrote: > Hi, > since many of our data are stored in MSSQL-Server databases we are > looking for an performance improved access to the data with mapserver > 5.2. Reading RFC 38 > (http://mapserver.gis.umn.edu/development/rfc/ms-rfc-38), we are keen to > try this plugin. The source code for the MSSQL Server 2008 plugin > already exists in the mapserver trunk, but the compiled dll is not > distributed with the recent ms4w packages up to now. We would appreciate > it very much if the the plugin dll could be included in the ms4w > distribution. looking at the nmake.opt file (http://trac.osgeo.org/mapserver/browser/trunk/mapserver/nmake.opt) it at least looks like we don't need mssql2008 to build the plugin, which is good.
- compiled dll for MS4W 2.2.9 is temporarily at: http://www.gatewaygeomatics.com/dl/buildkit/msplugin_mssql2008.zip - unzip at same root as existing ms4w install - dll will live in /ms4w/Apache/specialplugins - test the plugin in a layer (see example layer in: http://trac.osgeo.org/mapserver/browser/trunk/mapserver/rfc/ms-rfc-38.txt) - please comment in this bug after testing and let me know how it does (successful or not) so the dll can be added to the next release
I get the following error. msDrawMap(): Image handling error. Failed to draw layer named 'seclayer'. loadCustomLayerDLL: General error message. Failed to load dynamic Layer LIB: C:\ms4w\Apache\specialplugins\msplugin_mssql2008.dll msGetSymbol(): General error message. Can't find requested entry point: PluginInitializeVirtualTable in lib MZ�
Chad: I have posted another build of it, can you download it again and retry?
500 Internal server error on the web page Apache Error log reports: Premature end of script headers: mapserv.exe There is no entry in the mapserver log.
do you get any message when you execute shp2img with the -all_debug 5 switch?
No message with the shp2img either.
Unfortunately that could mean that there is a problem with the driver code. I have filed a MapServer ticket for this (http://trac.osgeo.org/mapserver/ticket/2768). You could also add yourself to that ticket in the CC list, and bug the MapServer developers into fixing this :)
Updated bug in Mapserver http://trac.osgeo.org/mapserver/ticket/2768 Please rebuild from svn and give it a try.
Chad: I have rebuilt the plugin with Assefa's changes: http://www.gatewaygeomatics.com/dl/buildkit/msplugin_mssql2008.zip Let us know how this one does. thanks.
It works. Thanks for your help. There are 2 other bugs I would like to report with this plugin. 1. PROCESSING "CLOSE_CONNECTION=DEFER" crashes mapserver 2. Polygon labels have spaces on the end causing labels to be shifted left. Where would the best place to report these?
Chad: excellent! I'll do an ms4w release with this plugin added. I'll mark this bug as fixed when I do that. The other bugs should be reported in MapServer Trac (http://trac.osgeo.org/mapserver/). Unfortunately there is no exact Trac Component for you to assign your mssql tickets to, so maybe use the "MapServer C Library" component for now, and assign it to "hobu", and add "jmckenna" and "assefa" to the CC list. Once those tickets are fixed you should then open MS4W tickets in this bugzilla so the changes can be added to a new release. Thanks for testing!
plugin has been added to the new ms4w-2.3.0 release.
