I had my IIS crash so severe after a windows update once that it forced me to switch to ms4w...
Mostly, it has to do with rights/authentication. Are you sure your IIS user is allowed to connect to your database? Daniel Walton schreef: > Paul, > > I got various errors with MapServer running in IIS 7.5 until I > installed the latest build of PHP. Don't know if you've done that > already, but I thought I would mention it. > > Regards, > > Dan Walton > gisfiretools.com <http://gisfiretools.com> > > > On Thu, Oct 22, 2009 at 9:29 AM, Paul james <paulj...@gmail.com > <mailto:paulj...@gmail.com>> wrote: > > Hi Tamas! > Thanks... > > Yes, thats working on Windows 2003/XP... > The problem is happening only on Windows 7 (IIS 7.5) now... > > > > > > HTTP Error 502.2 - Bad Gateway > > Do you have any idea what is that? Its work fine with postgis... > > Paul > > > On Wed, Oct 21, 2009 at 5:00 PM, Tamas Szekeres > <szeker...@gmail.com <mailto:szeker...@gmail.com>> wrote: > > Paul, > > I've set up your data but it works for me: > > 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> > > tried with the following binaries: > > http://vbkto.dyndns.org/sdk/release-1500-gdal-1-6-mapserver-5-4.zip > http://vbkto.dyndns.org/sdk/release-1500-gdal-mapserver.zip > > My mapfile: > > > MAP > NAME "SQL2008" > STATUS ON > SIZE 500 500 > IMAGETYPE PNG > IMAGECOLOR 254 254 254 > > EXTENT -79.7892 -44.2426 -24.9958 -9.11775 > > LAYER > > NAME "tblGeo_AmericaSul" > TYPE POLYGON > > CONNECTIONTYPE PLUGIN > PLUGIN "msplugin_mssql2008.dll" > CONNECTION > "server=.\MSSQLSERVER2008;database=Maps;Integrated Security=true" > DATA "the_geom from tblGeo_AmericaSul USING > UNIQUE CodigoAmericaSul USING SRID=0" > STATUS DEFAULT > > CLASS > STYLE > COLOR 255 0 0 > END > > END > END > END > > > Best regards, > > Tamas > > > > > > 2009/10/21 Paul james <paulj...@gmail.com > <mailto:paulj...@gmail.com>> > > Tamas, the actual error generated is: > HTTP Error 502.2 - Bad Gateway > > The specified CGI application misbehaved by not returning > a complete set of HTTP headers. The headers it did return > are "". > > Using Windos 7 (IIS 7) > > Testing on Windows 2003, I got just a Blank image (no > error message)... > > You can use the same mssql2008 data I sended you last time... > > Paul > > On Tue, Oct 20, 2009 at 4:56 PM, Tamas Szekeres > <szeker...@gmail.com <mailto:szeker...@gmail.com>> wrote: > > Paul, > > I couldn't reproduce your problem by using my data and > the recent mapserv version. > > http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=sql2008.map > > <http://vbkto.dyndns.org/cgi-bin/mapserv.exe?mode=map&map=sql2008.map> > > Could you provide your data for testing? > > Best regards, > > Tamas > > > 2009/10/20 Paul james <paulj...@gmail.com > <mailto:paulj...@gmail.com>> > > Hello Tamas > Did you test that? > Paul > On Mon, Oct 19, 2009 at 3:40 PM, Paul james > <paulj...@gmail.com <mailto:paulj...@gmail.com>> > wrote: > > Testing : > > http://localhost/cgi-bin-54/mapserv.exe?map=C:/Mapserver/Mapfile/map.map&mode=map > > <http://localhost/cgi-bin-54/mapserv.exe?map=C:/Mapserver/Mapfile/map.map&mode=map> > > Using Postgis connection works fine with same > setup... > Using that mapfile with MAPSCRIPT/C# works > fine as well... > > The problem is CGI + MSSQL2008 Plugin > > > Mapfile: > > MAP > EXTENT -79.7892 -34.2426 -24.9958 6.11775 > FONTSET "..\Fontes\Fontes.txt" > IMAGECOLOR 230 254 254 > IMAGETYPE png > SIZE 400 200 > STATUS ON > UNITS dd > NAME "Geral" > OUTPUTFORMAT > NAME "png" > MIMETYPE "image/png" > DRIVER "GD/PNG" > EXTENSION "png" > IMAGEMODE "PC256" > TRANSPARENT TRUE > END > > PROJECTION > 'proj=longlat' > 'ellps=WGS84' > 'datum=WGS84' > 'no_defs' > END > > WEB > IMAGEPATH 'C:\map\temp' > IMAGEURL '/tmp/' > QUERYFORMAT text/html > LEGENDFORMAT text/html > BROWSEFORMAT text/html > END > > LEGEND > STATUS ON > KEYSIZE 18 12 > KEYSPACING 10 5 > IMAGECOLOR 255 255 255 > LABEL > TYPE BITMAP > SIZE MEDIUM > COLOR 0 0 89 > END > TEMPLATE "..\template.html" > END > > QUERYMAP > COLOR 255 0 0 > SIZE -1 -1 > STATUS ON > STYLE hilite > END > > REFERENCE > EXTENT -79.7892 -34.2426 -24.9958 6.11775 > IMAGE "..\reference.png" > STATUS on > SIZE 221 150 > MINBOXSIZE 5 > MAXBOXSIZE 150 > COLOR -1 -1 -1 > OUTLINECOLOR 255 0 0 > MARKERSIZE 8 > END > > LAYER > NAME test > GROUP "tests" > TYPE POLYGON > STATUS ON > CONNECTIONTYPE PLUGIN > PLUGIN "msplugin_mssql2008.dll" > CONNECTION "server=x;Integrated > Security=false;database=x;uid=x;pwd=x" > DATA "the_geom from viwgeo_paisbrasil USING > UNIQUE oid USING SRID=0" > CLASS > COLOR 255 200 255 > END > END > END > > > > > > > > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > <mailto: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 > _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users