[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