<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Hi Michael,<br>
the GDAL/OGR library needs the "ogr_MSSQLSpatial.dll" file to
properly activate the MSSQLSpatial GDAL/OGR driver ("MSSQL:").<br>
<br>
You can check if the MSSQLSpatial GDAL/OGR driver is supported by
your ogr2ogr tool using the following command in the OSGeo4W Shell:<br>
<br>
ogr2ogr --formats | find "MSSQL"<br>
<br>
If it outputs the string "MSSQLSpatial -vector- (rw+): Microsoft SQL
Server Spatial Database (BCP)", then it means such driver is
supported, otherwise not.<br>
<br>
If you cannot use the OSGeo4W "Setup" program to install such file,
you can try to fix the issue just downloading the "gdal-mss" OSGeo4W
package from [1] and extracting from it the "ogr_MSSQLSpatial.dll"
file to the "\apps\gdal\lib\gdalplugins\" folder in your QGIS
installation dir.<br>
The exact "gdal-mss" OSGeo4W package to download depends on the
exact GDAL version installed with QGIS.<br>
<br>
Best regards.<br>
<br>
[1]
<a class="moz-txt-link-freetext" href="https://download.osgeo.org/osgeo4w/v2/x86_64/release/gdal/gdal-mss/?C=M&O=D">https://download.osgeo.org/osgeo4w/v2/x86_64/release/gdal/gdal-mss/?C=M&O=D</a><br>
<br>
<br>
<div class="moz-cite-prefix">Il 20/10/2022 16:56, Reetz, Michael
(NLPV) ha scritto:<br>
</div>
<blockquote type="cite"
cite="mid:58411f8bcc824209955376cda6a850f1@nlpvw.niedersachsen.de">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}@font-face
{font-family:"Time new Roman";
panose-1:0 0 0 0 0 0 0 0 0 0;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}code
{mso-style-priority:99;
font-family:"Courier New";}p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Tahoma",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US"><o:p></o:p></span><span
style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US"
lang="EN-US">I’ve found msodbcsql17.dll in C:\Program
Files\QGIS 3.22.8\bin\1033 and C:\Program Files\QGIS
3.22.8\bin.<o:p></o:p></span>
</p>
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif;mso-fareast-language:EN-US"
lang="EN-US">Gdal-mss seems not to be on my computer. But
since SQL Server Native Client isn’t supported by MS SQL
Server 2019 , this shouldn’t be a Problem.<o:p></o:p></span></p>
</div>
</blockquote>
</body>
</html>