[mapserver-dev] Beginning Mapserver & sql server 2008

[Wesley]

Hi Brent,

I've run the code and I've got the following answer:

msLoadMap(): 0.016s
msMSSQL2008LayerOpen called datastatement: geom from poligonogeom
MSMSSQL2008LayerOpen -- shared connection not available.
msConnPoolRegister(Camada1,server=luzon2\sqlexpress;uid=sa;pwd=senha1234;database=TESTE;Integrated
Security=false,020111
50)
msMSSQL2008LayerRetrievePK: query = SELECT     convert(varchar(50),
sys.columns.name) AS ColumnName, sys.indexes.name FR
OM         sys.columns INNER JOIN                      sys.indexes
INNER JOIN                      sys.tables ON sys.ind
exes.object_id = sys.tables.object_id INNER JOIN
sys.index_columns ON sys.indexes.object_id = sys.i
ndex_columns.object_id AND sys.indexes.index_id =
sys.index_columns.index_id ON                      sys.columns.object_
id = sys.index_columns.object_id AND sys.columns.column_id =
sys.index_columns.column_id WHERE     (sys.indexes.is_prima
ry_key = 1) AND (sys.tables.name = N'poligonogeom')
msMSSQL2008LayerParseData: unique column = geoid, srid='0',
geom_column_name = geom, table_name=poligonogeom
msMSSQL2008LayerFreeItemInfo called
msMSSQL2008LayerWhichShapes called
query_string_temp:SELECT geom.STAsBinary(),convert(varchar(20), geoid)
from poligonogeom WHERE geom.STIntersects(Geometr
y::STGeomFromText('POLYGON((-66 -25.2431077694236,-44
-25.2431077694236,-44 -8.75689223057644,-66 -8.75689223057644,-66
-25.2431077694236))',0)) = 1
msMSSQL2008LayerFreeItemInfo called
msMSSQL2008LayerClose datastatement: geom from poligonogeom
msConnPoolRelease(Camada1,server=luzon2\sqlexpress;uid=sa;pwd=senha1234;database=TESTE;Integrated
Security=false,0201115
0)
msConnPoolClose(server=luzon2\sqlexpress;uid=sa;pwd=senha1234;database=TESTE;Integrated
Security=false,02011150)
msDrawMap(): Layer 0 (Camada1), 0.171s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.171s
msSaveImage() total time: 0.000s
msFreeMap(): freeing map at 0187A510.
msMSSQL2008LayerClose datastatement: geom from poligonogeom
msMSSQL2008LayerClose -- layerinfo is  NULL
freeLayer(): freeing layer at 01F74160.
shp2img total time: 0.203s


When I run the query_string_temp:

query_string_temp:SELECT geom.STAsBinary(),convert(varchar(20), geoid)
from poligonogeom WHERE geom.STIntersects(Geometr
y::STGeomFromText('POLYGON((-66 -25.2431077694236,-44
-25.2431077694236,-44 -8.75689223057644,-66 -8.75689223057644,-66
-25.2431077694236))',0)) = 1

I got no results.



2009/6/30, Brent Fraser <bfraser at geoanalytic.com>:
> Wesley,
>
>    Try setting:
>
>     IMAGEURL "/ms_tmp/"
>
>
> And to test the rest of your map file, you may want to try Mapserver's
> command-line companion tool shp2img (ms4w puts it in \ms4w\Apache\cgi-bin):
>
>       shp2img -all_debug 5 -m mymapfile.map -o test.gif
>
> Best Regards,
> Brent Fraser
>
>
> Wesley wrote:
>> Hi all,
>>
>> It's my first time with mapserver, and I'm trying to use a map file
>> connected with sql server 2008. Mapserver is generating a blank image.
>> I think there is something wrong with my map file below.
>> Do you have any examples or tutorial about it?
>>
>> Thanks,
>> __________________________________________________________
>>
>>
>> MAP
>>  NAME "sample"
>>  STATUS ON
>>  SIZE 400 300
>>  IMAGETYPE gif
>>  EXTENT -66.00 -22.00 -44.00 -9.00
>>  UNITS DD
>>
>> #
>> # Start of web interface definition
>> #
>>  WEB
>>     TEMPLATE "D:\ms4w\Apache\htdocs\testesql.html"
>>     IMAGEPATH "D:\ms4w\tmp\ms_tmp\"
>>     IMAGEURL "/tmp/"
>>  END
>>
>>  LAYER
>>
>>   NAME "Camada1"
>>
>>   CONNECTIONTYPE PLUGIN
>>   PLUGIN "D:\ms4w\plugins\msplugin_mssql2008.dll"
>>
>>   CONNECTION
>> "server=luzon2\sqlexpress;uid=sa;pwd=senha1234;database=TESTE;Integrated
>> Security=false"
>>
>>   DATA "geom from lixo"
>>   TYPE POLYGON
>>
>>   STATUS ON
>>
>>    PROJECTION
>>       "init=epsg:4326"
>>    END
>>
>>    CLASS
>>      STYLE
>>        COLOR 0 0 255
>>        WIDTH 8
>>      END
>>    END
>>
>>  END
>>
>> END
>> _______________________________________________
>> mapserver-dev mailing list
>> mapserver-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>
>