[gdal-dev] OGR MS SQL Spatial driver has been added

[David Lowther]

Tamas,

 

Thanks for this great addition.  I pulled the latest working binaries and
can connect using ogrinfo and read datasets, but when trying to create I
receive the following:

 

D:\Utility\release-1600-x64-gdal-mapserver\bin\gdal\apps>ogr2ogr -f
MSSQLSpatial "MSSMSSQL:server=...;database=...;uid=...;pwd=..."
d:\data\ok\bia.shp

MSSQLSpatial driver failed to create
MSSMSSQL:server=...;database=...;uid=...;pwd=...

 

Here is a successful ogrinfo connect:

 

D:\Utility\release-1600-x64-gdal-mapserver\bin\gdal\apps>ogrinfo -al
"MSSQL:server=...;database=...;tables=pointdata;uid=...;pwd=... "

INFO: Open of
`MSSQL:server=...;database=...;tables=pointdata;uid=...;pwd=...'

 

      using driver `MSSQLSpatial' successful.

 

Layer name: pointdata

Geometry: Unknown (any)

Feature Count: 1

Extent: (100.000000, 100.000000) - (100.000000, 100.000000)

Layer SRS WKT:

(unknown)

FID Column = PKey

Geometry Column = Feature

WKT: String (0.0)

OGRFeature(pointdata):3

  WKT (String) = POINT (100 100)

  POINT (100 100)

 

I am certain that the user connecting to the database has sa rights. I've
tried more than one shapefile - and I know the shapefiles can be drawn by
Mapserver and seem valid when viewed from ogrinfo.

 

D:\Utility\release-1600-x64-gdal-mapserver\bin\gdal\apps>ogrinfo
d:\data\ok\bia.shp

INFO: Open of `d:\data\ok\bia.shp'

      using driver `ESRI Shapefile' successful.

1: bia (Polygon)

 

Any thoughts?

 

David Lowther

 

Coordinate Solutions, Inc.

 

  _____  

From: gdal-dev-bounces at lists.osgeo.org
[mailto:gdal-dev-bounces at lists.osgeo.org] On Behalf Of Tamas Szekeres
Sent: Sunday, September 12, 2010 10:23 AM
To: gdal-dev
Subject: [gdal-dev] OGR MS SQL Spatial driver has been added

 

Folks,

For those who interested, I've now added the initial revision of the OGR MS
SQL Spatial driver to the GDAL repository. For further information please
refer to the driver information
<http://www.gdal.org/ogr/drv_mssqlspatial.html>  page.
Working binaries (which always contain all the recent fixes) can be
downloaded from the daily build system available at:
http://vbkto.dyndns.org/sdk/

Since I didn't have the chance to test with all kind of the fancy spatial
data types any feedback on the potential issues are graciously accepted.

Upon the experiences gathered when writing this driver, I'm also planning to
add support for accessing the native SqlGeometry/SqlGeography serialization
format in the MapServer sql2008 driver which appears to provide a
significant increment in the performance of the data retrieval.


Best regards,

Tamas

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100913/d60ea74a/attachment.html