Bug report #15506

Importing geometry data from shapefile to SQL-Server via OSGeo4W fails

Added by Filip Mahieu about 5 years ago. Updated about 4 years ago.

Assignee:Nathan Woodrow
Affected QGIS version:2.8.3 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No Copied to github as #:23430


Since upgrading to QGis 2.14 (32-bits) the use of OSGeo4W to upload a shapefile to SQL-Server (2008R2) fails. Doing this with the QGis 2.8-version (32-bits) gives no problems.
It happens with every shapefile I tried.
I use this script:

ogr2ogr -f "MSSQLSpatial" "MSSQL:server=POV92;database=AtlasWL;trusted_connections:yes" "ACertainPath.shp" -a_srs "EPSG:33170"

I get a similar error message as stated in this stackexchange-issue:


Mine is:

ERROR 1: INSERT command for new feature failed.
ERROR 1: Unable to write feature 0 from layer ACertainPath.

ERROR 1: Terminating translation prematurely after failed translation of layer ACertainPath


#1 Updated by Nyall Dawson about 5 years ago

  • Resolution set to invalid
  • Status changed from Open to Closed

This doesn't sound like a QGIS bug - it needs to be filed on either the osgeo4w or gdal trackers.

#2 Updated by Jürgen Fischer about 4 years ago

  • Category set to Unknown

Also available in: Atom PDF