MsSqlSpatial support

[qgib]

Author Name: rstuven-gmail-com - (rstuven-gmail-com -)
Original Redmine Issue: 305

Redmine category:data_provider
Assignee: godofredo -

---

See
http://www.codeplex.com/Wiki/View.aspx?ProjectName=MsSqlSpatial

[qgib]

Author Name: Tim Sutton (Tim Sutton)

---

Changed to enhancement priority as major should be used for implemented features which are broken. I'm going to flag this for attention of Godofredo who is working on a generic sql access layer via gdal. Is [[MsSqlSpatial]] supported via gdal? Please advise.

Thanks

Tim

[qgib]

Author Name: Tim Sutton (Tim Sutton)

---

I'm also setting this for milestone 2.0.0 pending feedback.

[qgib]

Author Name: frdcn - (frdcn -)

---

Gdal/ogr does not have a driver for mssqlspatial but mssqlspatial databases can be read using ogr odbc driver

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

It seems that [[MySQL]] spatial extension is not widely used, not very actively developed: http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
It is possible that spatial information can however be read through OGR: http://www.gdal.org/ogr/drv_mysql.html
I would suggest to close this ticket.

[qgib]

Author Name: Volker Fröhlich (@volter)

---

I also misread in the first place: It's about MS-SQL, not [[MySQL]]:

http://www.gdal.org/ogr/drv_mssqlspatial.html

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

I think this should be solved within GDAL/OGR, I do not see a point in writing a db provider for this. Please reopen if I'm wrong.

---

• status_id was changed from Open to Closed
• resolution was configured as upstream

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

http://szekerest.blogspot.com/2010/09/ogr-ms-sql-2008-spatial-driver.html