Hi Michael,
the GDAL/OGR library needs the "ogr_MSSQLSpatial.dll" file to properly
activate the MSSQLSpatial GDAL/OGR driver ("MSSQL:").
You can check if the MSSQLSpatial GDAL/OGR driver is supported by your
ogr2ogr tool using the following command in the OSGeo4W Shell:
ogr2ogr --formats | find "MSSQL"
If it outputs the string "MSSQLSpatial -vector- (rw+): Microsoft SQL
Server Spatial Database (BCP)", then it means such driver is supported,
otherwise not.
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.
The exact "gdal-mss" OSGeo4W package to download depends on the exact
GDAL version installed with QGIS.
Best regards.
[1]
https://download.osgeo.org/osgeo4w/v2/x86_64/release/gdal/gdal-mss/?C=M&O=D
Il 20/10/2022 16:56, Reetz, Michael (NLPV) ha scritto:
I’ve found msodbcsql17.dll in C:\Program Files\QGIS 3.22.8\bin\1033
and C:\Program Files\QGIS 3.22.8\bin.
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.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
