<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV></DIV>
<DIV>Thanks for you answer Brent...</DIV>
<DIV> </DIV>
<DIV>I have another answer...</DIV>
<DIV> </DIV>
<DIV>I found this page :</DIV>
<DIV> </DIV>
<DIV><A href="http://www.online-archaeology.co.uk/wordpress/?p=10">http://www.online-archaeology.co.uk/wordpress/?p=10</A></DIV>
<DIV> </DIV>
<DIV>But in this page appear something about pass a parameter to the SQL Server store procedure :</DIV>
<DIV> </DIV>
<DIV><FONT face="Courier New">CONNECTION "<OGRVRTDataSource><BR> <OGRVRTLayer name='POW'><BR> <SrcDataSource>ODBC:id/pwd@MyDSN</SrcDataSource> <BR> <FONT color=#c00000><SrcSQL>EXEC NameofStoredProcedure '%param%'</SrcSQL> <BR></FONT> <GeometryType>wkbPoint</GeometryType> <BR> <LayerSRS>WGS84</LayerSRS><BR> <GeometryField encoding='PointFromColumns' x='Longitude' y='Latitude'/> <BR> </OGRVRTLayer><BR> </OGRVRTDataSource>"<BR> STATUS ON<BR> DATA POW</FONT><BR>.</DIV>
<DIV>.</DIV>
<DIV>.</DIV>
<DIV> </DIV>
<DIV>But how can I pass the parameter to the store procedure from my page? I supose that I have to create a fields for the data entry, but somebody knows how to code the parameter pass to the mapfile?</DIV>
<DIV> </DIV>
<DIV>Best Regards...</DIV>
<DIV><BR> </DIV>
<DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">De:</SPAN></B> Brent Fraser <bfraser@geoanalytic.com><BR><B><SPAN style="FONT-WEIGHT: bold">Para:</SPAN></B> Christian Canales <ccanales29@yahoo.es><BR><B><SPAN style="FONT-WEIGHT: bold">CC:</SPAN></B> mapserver-dev@lists.osgeo.org; szekerest@gmail.com<BR><B><SPAN style="FONT-WEIGHT: bold">Enviado:</SPAN></B> lunes, 15 de junio, 2009 21:49:56<BR><B><SPAN style="FONT-WEIGHT: bold">Asunto:</SPAN></B> Re: [mapserver-dev] ODBC Connection...<BR></FONT><BR>Christian,<BR><BR> Assuming your ODBC datasource is connecting to your database, you may<BR>need to specify the spatial reference system of your data, either in the<BR>VRT spec below using <LayerSRS>, or in the LAYER object of your map file<BR>with a PROJECTION object.<BR><BR>You could try adding "DEBUG 5" to the layer definition and using shp2img<BR>to see if it reports any errors.<BR><BR>Best Regards,<BR>Brent Fraser<BR><BR><BR><BR><BR>> Hi
All...<BR>><BR>> I'm trying to connect my map with some MS SQL Server data...<BR>><BR>> So, I'm trying to do it using an ODBC connection via OGR in a *.OVF<BR>> file...<BR>><BR>> This is the code in the file:<BR>><BR>> <OGRVRTDataSource><BR>> <OGRVRTLayer name="cartracks"><BR>> <SrcDataSource>ODBC:trak/trakrm@webtrak</SrcDataSource><BR>> <SrcSQL>SELECT TOP 1 ID FROM Guardar WHERE ID='53377'</SrcSQL><BR>> <GeometryType>wkbPoint</GeometryType><BR>> <GeometryField encoding="PointFromColumns" x="Lon" y="Lat"/><BR>> </OGRVRTLayer><BR>> </OGRVRTDataSource><BR>><BR>> But I cannot see anything...<BR>><BR>> Somebody knows what is wrong?<BR>><BR>> I'm in a Linux environment, with Mapserver 5.4.0 and
Chameleon...<BR>><BR>> Thanks...<BR>><BR>><BR>><BR>><BR>> _______________________________________________<BR>> mapserver-dev mailing list<BR>> <A href="mailto:mapserver-dev@lists.osgeo.org" ymailto="mailto:mapserver-dev@lists.osgeo.org">mapserver-dev@lists.osgeo.org</A><BR>> <A href="http://lists.osgeo.org/mailman/listinfo/mapserver-dev" target=_blank>http://lists.osgeo.org/mailman/listinfo/mapserver-dev</A><BR>><BR>><BR><BR><BR></DIV></DIV></DIV></div><br>
</body></html>