We (so I do not remember the details) managed to get it working circa 5 years ago using unixODBC. Since then, Microsoft have released an official ODBC driver for macOS, https://www.microsoft.com/en-us/download/details.aspx?id=56567

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 <mailto: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 <mailto: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


--
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

_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to