I have been using ogr2ogr.exe v2.1.0 to import SHP files to MSSQL for
several years, no problem.

Recently installed GDAL 3.3.1 and this version of ogr2ogr no longer imports
SHP, only creates empty table.

Steps to reproduce the problem.

I have tried both versions on same machine - v2.1.0 works and v 3.31 does
not

The command line for v2.1.0 is:

c:\OSGeo4w_2016\bin\ogr2ogr.exe -overwrite -progress -f "MSSQLSpatial" -lco
SCHEMA=QGIS "MSSQL:server=xxxx_17;database=DHLog;trusted_connection=yes"
"d:\temp\FRO_ELs-MLs.shp" -nln QGIS.frome_els_mls

The command line for v3.3.1 is same, other than using the new EXE

c:\OSGeo4w\bin\ogr2ogr.exe -overwrite -progress -f "MSSQLSpatial" -lco
SCHEMA=QGIS "MSSQL:server=xxxx_17;database=DHLog;trusted_connection=yes"
"d:\temp\FRO_ELs-MLs.shp" -nln QGIS.frome_els_mls

v2.1.0 imports the SHP just fine to MSSQL, but v 3.3.1 only creates the
table and then no records

Attached is the SHP file and its ancillaries

Operating system

Win 10 Pro, 64 bit

With thanks

 

Luke B

<<attachment: FRO_ELs-MLs.zip>>

_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to