Thank you very much for the quick reply, I will check those links right now.<br>
<br>
Thanks,<br>
<br>
Matt<br><br><div><span class="gmail_quote">On 9/24/05, <b class="gmail_sendername">Frank Warmerdam</b> <<a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 9/24/05, Matthew Edmondson <<a href="mailto:matt0177@gmail.com">matt0177@gmail.com</a>> wrote:<br>> I'm running Mapserver 4.6 with Chameleon and to this point only utilizing<br>> local shapefiles. I'm now going to be required to pull data from a msSQL
<br>> table with lat and long points stored. I have a couple of quick questions.<br>><br>> 1: How do I write the connection string to a msSQL db.<br><br>Matt,<br><br>You would use CONNECTIONTYPE OGR and a CONNECTION string like
<br>"ODBC:MyDSN" where MyDSN is the DSN you setup for the Microsoft<br>SQL Server dataset in question. You might want to skim the OGR ODBC<br>driver page at:<br><br> <a href="http://www.gdal.org/ogr/drv_odbc.html">
http://www.gdal.org/ogr/drv_odbc.html</a><br><br>> 2: What format does the geo data need to be in the table. Currently, the<br>> lat/long is in decimal degrees in 2 different columns, is that appropriate,<br>> if not, what format does it need to be in.
<br><br>That should be fine, but there is still the issue of identifying the columns<br>to be used as spatial columns. For this you will need to setup an<br>OGR Virtual File (often extension .ovf). These are documented at:
<br><br> <a href="http://www.gdal.org/ogr/drv_vrt.html">http://www.gdal.org/ogr/drv_vrt.html</a><br><br>There is also a detailed wiki topic on the use of virtual files to access data<br>from ODBC connections such as yours. I don't recall the url but you could
<br>dig around for it if the above isn't enough info.<br><br>Best regards,<br>--<br>---------------------------------------+--------------------------------------<br>I set the clouds in motion - turn up | Frank Warmerdam,
<a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a><br>light and sound - activate the windows | <a href="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</a><br>and watch the world go round - Rush | Geospatial Programmer for Rent
<br></blockquote></div><br>