Hi Stefan<br><br>I've been asked to implement SQL Server 2008 support in OGR, and add data source creation support with the ODBC driver, but the company finally couldn't sponsor this project so this effort have been stopped.<br>
<br>The current ODBC implementation can connect to the SQL Server databases but the geometry field can only be a valid WKB binary field or a WKT text field. Your could also use the OGR VRT driver attached to the ODBC driver to extract point geometries from X,Y coordinates in a non-spatial database table.<br>
<br><br>Best regards,<br><br>Tamas<br><br><br><br><br><br><div class="gmail_quote">2009/5/22 Stefan Zaunseder <span dir="ltr"><<a href="mailto:sz@giscad.de">sz@giscad.de</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello list,<br>
<br>
is there any ongoing work or are there any plans for a SQL Server (Version 2008, which supports geographic/geometric data) driver in OGR? Or is it possible to use the ODBC driver for SQL Server in a reasonable manner?<br>
<br>
If not, is anybody except us interested in such a driver?<br>
<br>
Regards,<br>
<br>
Stefan Zaunseder<br>
<br>
-- <br>
<br>
GISCAD-Institut - Prof. Dr. Gerd Peyke, Dipl.-Inform. Stefan Zaunseder<br>
Büro LA - Moosburger Straße 8 - 84169 Altfraunhofen<br>
Fon: 08705/1377 - Fax: 08705/1367<br>
<a href="http://www.giscad.de/" target="_blank">http://www.giscad.de/</a><br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote></div><br>