Bug report #15506

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

Added by Filip Mahieu over 7 years ago. Updated over 6 years ago.

Status:Closed
Priority:Normal
Assignee:Nathan Woodrow
Category:Unknown
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

Description

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:

http://gis.stackexchange.com/questions/200884/writing-shapefile-to-sql-server-database-with-ogr2ogr-error?rq=1

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

History

#1 Updated by Nyall Dawson over 7 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 over 6 years ago

  • Category set to Unknown

Also available in: Atom PDF