i have the following Layer:<br><br>LAYER<br> NAME "estados"<br> METADATA<br> "wms_title" "Estados"<br> END <br> TYPE polygon<br> STATUS ON<br> CONNECTIONTYPE PLUGIN<br>
PLUGIN "C:/ms4w/Apache/specialplugins/msplugin_mssql2008.dll" <br> CONNECTION "server=LENNY\DEV2008;port=49222;uid=sa;pwd=Stigeo_1_adm_1;database=teste_geo;Integrated Security=false"<br>
DATA "GEOM from estados USING UNIQUE OBJECTID USING SRID=4326" <br> <br> CLASS<br> NAME "estados" <br> STYLE<br> COLOR 255 0 0 <br> END<br>
END<br> <br> END <br> END <br><br>when i execute:<br><br>shp2img -m c:/ms4w/apps/sintaq/rodovias/example.map -all_debug 5<br><br>return this:<br><br>msLoadMap(): 0.000s<br>msDrawMap(): rendering using outputformat named png (AGG/PNG).<br>
msDrawMap(): WMS/WFS set-up and query, 0.000s<br>msMSSQL2008LayerOpen called datastatement: GEOM from estados USING UNIQUE OBJECTID USING SRID=4326<br>MSMSSQL2008LayerOpen -- shared connection not available.<br>msConnPoolRegister(estados,server=I REMOVED IT FROM TEXT,03ABD200)<br>
msMSSQL2008LayerParseData: unique column = OBJECTID, srid='4326', geom_column_name = GEOM, table_name=estados<br>msMSSQL2008LayerFreeItemInfo called<br>msMSSQL2008LayerWhichShapes called<br>query_string_temp:SELECT GEOM.STAsBinary(),convert(varchar(36), OBJECTID) from estados WHERE GEOM.STIntersects(geometry::STGeomFromText('POLYGON((-77.9477842994432 -33.731964,-30.6475117005568 -33.731964,-30.6475117005568 4.9525941,-77.9477842994432 4.9525941,-77.9477842994432 -33.731964))',4326)) = 1<br>
msMSSQL2008LayerFreeItemInfo called<br>msMSSQL2008LayerClose datastatement: GEOM from estados USING UNIQUE OBJECTID USING SRID=4326<br>msConnPoolRelease(estados,server=I REMOVED IT FROM TEXT,03ABD200)<br>msConnPoolClose(server=I REMOVED IT FROM TEXT,03ABD200)<br>
msDrawMap(): Layer 0 (estados), 0.094s<br>msDrawMap(): Drawing Label Cache, 0.000s<br>msDrawMap() total time: 0.096s<br>SaveImage(stdout) total time: 0.053s<br>msFreeMap(): freeing map at 0216C0A0.<br>msMSSQL2008LayerClose datastatement: GEOM from estados USING UNIQUE OBJECTID USING SRID=4326<br>
msMSSQL2008LayerClose -- layerinfo is NULL<br>freeLayer(): freeing layer at 0216F350.<br>shp2img total time: 0.152s<br><br><br>the output image return with no data, <br>if i execute the map file in mapserver url the output is null too.<br>
I can't find any issue about this, anyone can help me?<br><br><br clear="all"><br>-- <br>Rodrigo Silva de Melo<br>