This is a tricky driver. It uses ODBC (iODBC on macOS). You need an ODBC driver for the MSSQL database for the Mac's iODBC. GDAL doesn't know about installed ODBC drivers until you try to use them, so ogrinfo --formats will say MSSQL is supported.
I don't know if any ODBC drivers are available on macOS for MSSQL. > On Feb 13, 2019, at 2:39 PM, Horn, Ian I (COT) <ian.h...@ky.gov> wrote: > > 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 ----- William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> http://www.kyngchaos.com/ The equator is so long, it could encircle the earth completely once.
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
