<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p>Note: already reported at
<a class="moz-txt-link-freetext" href="https://github.com/OSGeo/gdal/issues/4674">https://github.com/OSGeo/gdal/issues/4674</a></p>
<p><br>
</p>
<div class="moz-cite-prefix">Le 18/10/2021 à 19:59,
<a class="moz-txt-link-abbreviated" href="mailto:laburlet@gmail.com">laburlet@gmail.com</a> a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:024401d7c449$eaaafc90$c000f5b0$@gmail.com">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<div class="WordSection1">
<p class="MsoNormal"><span>I have been using ogr2ogr.exe v2.1.0
to import SHP files to MSSQL for several years, no problem.</span></p>
<p class="MsoNormal"><span>Recently installed GDAL 3.3.1 and
this version of ogr2ogr no longer imports SHP, only creates
empty table.</span></p>
<p class="MsoNormal"><span>Steps to reproduce the problem.</span></p>
<p class="MsoNormal"><span>I have tried both versions on same
machine - v2.1.0 works and v 3.31 does not</span></p>
<p class="MsoNormal"><span>The command line for v2.1.0 is:</span></p>
<p class="MsoNormal"><b><span>c:\OSGeo4w_2016</span></b><span>\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</span><span></span></p>
<p class="MsoNormal"><span>The command line for v3.3.1 is same,
other than using the new EXE</span></p>
<p class="MsoNormal"><b><span>c:\OSGeo4w</span></b><span>\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</span><span></span></p>
<p class="MsoNormal"><span>v2.1.0 imports the SHP just fine to
MSSQL, but v 3.3.1 only creates the table and then no
records</span></p>
<p class="MsoNormal"><span>Attached is the SHP file and its
ancillaries</span></p>
<p class="MsoNormal"><span>Operating system</span></p>
<p class="MsoNormal"><span>Win 10 Pro, 64 bit</span></p>
<p class="MsoNormal">With thanks</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Luke B</p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>