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-boun...@lists.osgeo.org
[mailto:gdal-dev-boun...@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
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
