Paul,<br><br>I've set up your data but it works for me:<br><br><a href="http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=mssql2008.map">http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=mssql2008.map</a><br>
<br>tried with the following binaries:<br><br><a href="http://vbkto.dyndns.org/sdk/release-1500-gdal-1-6-mapserver-5-4.zip">http://vbkto.dyndns.org/sdk/release-1500-gdal-1-6-mapserver-5-4.zip</a><br><a href="http://vbkto.dyndns.org/sdk/release-1500-gdal-mapserver.zip">http://vbkto.dyndns.org/sdk/release-1500-gdal-mapserver.zip</a><br>
<br>My mapfile:<br><br><br>MAP<br> NAME "SQL2008"<br> STATUS ON<br> SIZE 500 500<br> IMAGETYPE PNG<br> IMAGECOLOR 254 254 254<br> <br> EXTENT -79.7892 -44.2426 -24.9958 -9.11775<br><br> LAYER <br>
<br> NAME "tblGeo_AmericaSul"<br> TYPE POLYGON<br> CONNECTIONTYPE PLUGIN<br> PLUGIN "msplugin_mssql2008.dll"<br> CONNECTION "server=.\MSSQLSERVER2008;database=Maps;Integrated Security=true"<br>
DATA "the_geom from tblGeo_AmericaSul USING UNIQUE CodigoAmericaSul USING SRID=0"<br> STATUS DEFAULT<br> <br> CLASS<br> STYLE<br> COLOR 255 0 0<br>
END<br> <br> END<br> END<br>END<br><br><br>Best regards,<br><br>Tamas<br><br><br><br><br><br><div class="gmail_quote">2009/10/21 Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>Tamas, the actual error generated is:</div>
<div>HTTP Error 502.2 - Bad Gateway<div class="im"><br>The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are "".</div></div>
<div> </div>
<div>Using Windos 7 (IIS 7)</div>
<div> </div>
<div>Testing on Windows 2003, I got just a Blank image (no error message)...</div>
<div> </div>
<div>You can use the same mssql2008 data I sended you last time...</div>
<div> </div><font color="#888888">
<div>Paul<br> </div></font><div><div></div><div class="h5">
<div class="gmail_quote">On Tue, Oct 20, 2009 at 4:56 PM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;" class="gmail_quote">Paul,<br><br>I couldn't reproduce your problem by using my data and the recent mapserv version.<br>
<a href="http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=sql2008.map" target="_blank">http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=sql2008.map</a><br>
<br>Could you provide your data for testing?<br><br>Best regards,<br><br>Tamas<br><br><br>
<div class="gmail_quote">2009/10/20 Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.com</a>></span>
<div>
<div></div>
<div><br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div>Hello Tamas</div>
<div>Did you test that?<br></div><font color="#888888">
<div>Paul<br></div></font>
<div>
<div></div>
<div>
<div class="gmail_quote">On Mon, Oct 19, 2009 at 3:40 PM, Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;" class="gmail_quote">
<div> Testing :</div>
<div><a href="http://localhost/cgi-bin-54/mapserv.exe?map=C:/Mapserver/Mapfile/map.map&mode=map" target="_blank">http://localhost/cgi-bin-54/mapserv.exe?map=C:/Mapserver/Mapfile/map.map&mode=map</a></div>
<div> </div>
<div>Using Postgis connection works fine with same setup...</div>
<div>Using that mapfile with MAPSCRIPT/C# works fine as well...</div>
<div> </div>
<div>The problem is CGI + MSSQL2008 Plugin</div>
<div> </div>
<div><br>Mapfile:</div>
<div> </div>
<div> MAP<br> EXTENT -79.7892 -34.2426 -24.9958 6.11775<br> FONTSET "..\Fontes\Fontes.txt"<br> IMAGECOLOR 230 254 254<br> IMAGETYPE png<br> SIZE 400 200<br> STATUS ON<br> UNITS dd<br> NAME "Geral" <br>
</div>
<div> OUTPUTFORMAT<br> NAME "png"<br> MIMETYPE "image/png"<br> DRIVER "GD/PNG"<br> EXTENSION "png"<br> IMAGEMODE "PC256"<br> TRANSPARENT TRUE<br> END<br> <br> PROJECTION<br>
'proj=longlat'<br> 'ellps=WGS84'<br> 'datum=WGS84'<br> 'no_defs'<br> END</div>
<div> </div>
<div> WEB<br> IMAGEPATH 'C:\map\temp'<br> IMAGEURL '/tmp/'<br> QUERYFORMAT text/html<br> LEGENDFORMAT text/html<br> BROWSEFORMAT text/html<br> END<br> </div>
<div> LEGEND<br> STATUS ON<br> KEYSIZE 18 12<br> KEYSPACING 10 5<br> IMAGECOLOR 255 255 255<br> LABEL<br> TYPE BITMAP<br> SIZE MEDIUM<br> COLOR 0 0 89<br> END<br> TEMPLATE "..\template.html" <br> END <br>
<br> QUERYMAP<br> COLOR 255 0 0<br> SIZE -1 -1<br> STATUS ON<br> STYLE hilite<br> END<br> <br> REFERENCE<br> EXTENT -79.7892 -34.2426 -24.9958 6.11775<br> IMAGE "..\reference.png"<br> STATUS on<br> SIZE 221 150<br>
MINBOXSIZE 5<br> MAXBOXSIZE 150<br> COLOR -1 -1 -1<br> OUTLINECOLOR 255 0 0<br> MARKERSIZE 8<br> END </div>
<div> </div>
<div> LAYER<br> NAME test</div>
<div> GROUP "tests"<br> TYPE POLYGON<br> STATUS ON<br> CONNECTIONTYPE PLUGIN <br> PLUGIN "msplugin_mssql2008.dll" <br> CONNECTION "server=x;Integrated Security=false;database=x;uid=x;pwd=x"<br>
DATA "the_geom from viwgeo_paisbrasil USING UNIQUE oid USING SRID=0"<br> CLASS<br> COLOR 255 200 255<br> END<br> END </div>
<div>END</div></blockquote></div><br></div></div></blockquote></div></div></div><br></blockquote></div><br>
</div></div></blockquote></div><br>