[gdal-dev] Appending to MSSQL-tables

[Niels Kjøller Hansen]

Hi all

I have been running a script daily, which worked with GDAL 1.10

ogr2ogr -append -lco GEOM_NAME="geometry" -f "MSSQLSpatial"
"MSSQL:server=YYYYYY;database=XXXXXX;trusted_connection=yes"
lokalplaner_vedtaget.gml -a_srs "EPSG:25832" -lco SCHEMA=ZZZZ -nln
lokalplaner_vedtaget --debug ON

But, now it seems that it does not. What can I do?:
"GML: Using Expat reader
HTTP: Fetch(
http://geoservice.plansystem.dk:80/wfs?service=WFS&version=1.0.0&request=DescribeFeatureType&typeName=pdk%3Atheme_pdk_lokalplan_vedtaget_v
)
GML: Using /vsimem/tmp_gml_xsd_000000000082F870.xsd
OGR: OGROpen(lokalplaner_vedtaget.gml/000000000082F870) succeeded as GML.
OGR_MSSQLSpatial:
EstablishSession(Connection:"server=YYYYYYY;database=XXXXXX;trusted_connection=yes")
ODBC: SQLDriverConnect(DRIVER=SQL
Server;server=YYYYYY;database=XXXXXX;trusted_connection=yes)
OGR:
OGROpen(MSSQL:server=YYYYYYY;database=XXXXX;trusted_connection=yes/000000000035EE10)
succeeded as MSSQLSpatial
.
ERROR 1: Layer lokalplaner_vedtaget already exists, CreateLayer failed. Use
the layer creation option OVERWRITE=YES to replace it.
GML: ResetReading()
ERROR 1: Terminating translation prematurely after failed translation of
layer theme_pdk_lokalplan_vedtaget_v (use -skipfailures to skip errors)

ODBC: SQLDisconnect()"

The gml file is downloaded from a WFS for debugging purposes, could that
make a difference?

What is the difference between the -overwrite flag and the "OVERWRITE=YES"
layer creation option? Is an lco "APPEND=YES" a possibility?

Thanks,
Niels :-)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20141205/09b023b4/attachment.html>