[Qgis-user] ogr2ogr doesn't connect to MS SQL Server

[Reetz, Michael (NLPV)]

Hello Jürgen and all,

thank you all for your help. I could solve my problem with the field calculator and the command you've sent me, Jürgen.

Since the GDAL/ogr MS SQL Server driver is obviously missing on my computer, I will see if I can get a complete installation of the current GDAL package. This would be very helpful in many situations, especially in scripts that perform transformation tasks.

Best regards

Michael

-----Ursprüngliche Nachricht-----
Von: Qgis-user <qgis-user-bounces at lists.osgeo.org> Im Auftrag von Jürgen E. Fischer via Qgis-user
Gesendet: Donnerstag, 20. Oktober 2022 16:33
An: qgis-user at lists.osgeo.org
Betreff: Re: [Qgis-user] ogr2ogr doesn't connect to MS SQL Server

ACHTUNG!! Diese E-Mail erreicht Sie von einem Absender außerhalb der niedersächsischen Landesverwaltungs-Infrastruktur mit TLS-Verschlüsselung. Bitte klicken Sie auf keine Links oder öffnen Sie keine E-Mail-Anhänge, falls Sie den Absender nicht kennen und nicht wissen, ob der Inhalt sicher ist.

Hi,

On Thu, 20. Oct 2022 at 16:29:02 +0200, Jürgen E. Fischer wrote:
> QGIS has a native MSSQL provider and doesn't need GDAL/OGR with MSSQL support.
> But you can install gdal-mss (from OSGeo4W setup; also included in the
> standalone) to add that.

BTW that's probably new in OSGeo4W since the switch to GDAL 3.5.  Earlier MSSQL support was also built in and the plugin would just add support for bulk copy.


Jürgen

--
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden            https://www.norbit.de
QGIS release manager (PSC)  Germany                 IRC: jef on Libera|OFTC