Note: already reported at https://github.com/OSGeo/gdal/issues/4674


Le 18/10/2021 à 19:59, [email protected] a écrit :

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


_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev

--
http://www.spatialys.com
My software is free, but my time generally not.

_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to