Andreas, here’s what I get when:
Ians-iMac:~ ianhorn$ ogrinfo --formats | grep MS MSSQLSpatial -vector- (rw+): Microsoft SQL Server Spatial Database XLS -vector- (ro): MS Excel format XLSX -vector- (rw+v): MS Office Open XML spreadsheet On Feb 13, 2019, at 3:00 PM, gdal-dev-requ...@lists.osgeo.org<mailto:gdal-dev-requ...@lists.osgeo.org> wrote: Send gdal-dev mailing list submissions to gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> To subscribe or unsubscribe via the World Wide Web, visit https://lists.osgeo.org/mailman/listinfo/gdal-dev or, via email, send a message with subject or body 'help' to gdal-dev-requ...@lists.osgeo.org You can reach the person managing the list at gdal-dev-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gdal-dev digest..." Today's Topics: 1. Re: MSSQL Driver on Mac (Peter Petrik) 2. Re: MSSQL Driver on Mac (Andreas Oxenstierna) ---------------------------------------------------------------------- Message: 1 Date: Wed, 13 Feb 2019 15:26:06 +0100 From: Peter Petrik <peter.pet...@lutraconsulting.co.uk> To: "Horn, Ian I (COT)" <ian.h...@ky.gov> Cc: "gdal-dev@lists.osgeo.org" <gdal-dev@lists.osgeo.org> Subject: Re: [gdal-dev] MSSQL Driver on Mac Message-ID: <ca+t_msjpesiwadwctm3zqrnmt_8ftro_kj4urje0kga0uw5...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi, which installation do you use? Cheers, Peter On Wed, Feb 13, 2019 at 3:14 PM Horn, Ian I (COT) <ian.h...@ky.gov> wrote: I am trying to access a SQL Server on QGIS, but I get the “error opening connection: Driver not loaded Driver not loaded”. QGIS installs GDAL 2.3.2. On my PC I know how to get to the root folders and check to see if the driver is there but not on my Mac. If I use my terminal I get the following: Unable to open datasource `mssql:server=XXXXXXXXX;database=XXXX;tables=XXXXX.TrafficCameras;XXXXXX; ' with the following drivers. How do I install or make this driver work on my Mac for both command line and use in QGIS? Thanks, Ian _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/a0a61fdb/attachment-0001.html> ------------------------------ Message: 2 Date: Wed, 13 Feb 2019 15:27:54 +0100 From: Andreas Oxenstierna <a...@t-kartor.se> To: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] MSSQL Driver on Mac Message-ID: <0a58531e-caab-7ce7-f0de-d1fd58917...@t-kartor.se> Content-Type: text/plain; charset="utf-8"; Format="flowed" What is ogrinfo reporting? ogrinfo --formats | grep MS For me (macOS 10.14.2 GDAL 2.3.2) it reports: MSSQLSpatial -vector- (rw+): Microsoft SQL Server Spatial Database I am trying to access a SQL Server on QGIS, but I get the “error opening connection: Driver not loaded Driver not loaded”. QGIS installs GDAL 2.3.2. On my PC I know how to get to the root folders and check to see if the driver is there but not on my Mac. If I use my terminal I get the following: Unable to open datasource `mssql:server=XXXXXXXXX;database=XXXX;tables=XXXXX.TrafficCameras;XXXXXX; ' with the following drivers. How do I install or make this driver work on my Mac for both command line and use in QGIS? Thanks, Ian _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev -- Hälsningar Andreas Oxenstierna T-Kartor Geospatial AB Olof Mohlins väg 12 Kristianstad mobile: +46 733 206831 mailto: a...@t-kartor.se http://www.t-kartor.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/0fbf5c3a/attachment-0001.html> ------------------------------ Subject: Digest Footer _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev ------------------------------ End of gdal-dev Digest, Vol 177, Issue 19 *****************************************
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
