Michael and list, I don't use Microsoft SQL Server, so not speaking from experience here but this doesn't help?
https://gdal.org/drivers/vector/mssqlspatial.html On Thu, Oct 20, 2022 at 1:40 AM Reetz, Michael (NLPV) via Qgis-user < qgis-user@lists.osgeo.org> wrote: > Hello all, > > > > it seems that nobody has an idea. I’ve found some tips (some of them > really old) to install the latest ODBC-Driver from Microsoft or the SQL > Server Native Client. First is installed, second is not supported in SQL > Server 2019. Another tip was to rename or delete ogr_MSSPATIAL.dll but this > dll isn’t installed on my system (obviously not part of the QGIS > installation package). > > > > So, it looks as if ogr2ogr is not really helpful for me and I have to look > for another tool. > > > > Best regard > > Michael > > > > *Von:* Qgis-user <qgis-user-boun...@lists.osgeo.org> *Im Auftrag von *Reetz, > Michael (NLPV) via Qgis-user > *Gesendet:* Mittwoch, 19. Oktober 2022 12:50 > *An:* qgis-user@lists.osgeo.org > *Betreff:* [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. > > Dear QGIS users, > > > > we are using MS SQL Server 2019 as basis for Geoserver and GIS software. > There are a lot of tables that have attributes of the types geometry and/or > geography. I can load these tables into QGIS (3.22.8) projects without any > problems. > > > > Now I’m asked to add an geography attribute to one table that has already > an geometry attribute and populate it with coordinates by transforming the > geometry values. I’ve found code how to do this with ogr2ogr but when I run > it I receive the error message “Unable to open datasource ‘MSSQL:server=<my > server IP>;database=<my database>;trusted_connection=yes;' with the > following drivers”. MSSQLSpatial is not listed but should be part of the > ODBC driver. Any idea? Which driver QGIS is using? > > > > Best regards > > > > Michael > > > > > > > > ***************************************** > > Michael Reetz > > Datenbanken und Anwendungsentwicklung > Nationalpark-Verwaltung Niedersächsisches Wattenmeer > Virchowstr. 1 | 26382 Wilhelmshaven > Tel.: +49 (0) 4421 911 291 > e-mail: michael.re...@nlpvw.niedersachsen.de > <michael.re...@nlpv-wattenmeer.niedersachsen.de> > Web: https://www.*nationalpark-wattenmeer.de > <http://nationalpark-wattenmeer.de>* > > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > -- Chris Hermansen · clhermansen "at" gmail "dot" com C'est ma façon de parler.
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user