[gdal-dev] ogr2ogr.exe v3.3.1 only results in blank table

laburlet at gmail.com laburlet at gmail.com
Mon Oct 18 10:59:34 PDT 2021


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20211019/d848d0a0/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FRO_ELs-MLs.zip
Type: application/x-zip-compressed
Size: 25507 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20211019/d848d0a0/attachment-0001.bin>


More information about the gdal-dev mailing list