<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">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.<div class=""><br class=""></div><div class="">I don't know if any ODBC drivers are available on macOS for MSSQL.</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Feb 13, 2019, at 2:39 PM, Horn, Ian I (COT) <<a href="mailto:Ian.Horn@ky.gov" class="">Ian.Horn@ky.gov</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Andreas, here’s what I get when:
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class="">Ians-iMac:~ ianhorn$ ogrinfo --formats | grep MS</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class=""> MSSQLSpatial -vector- (rw+): Microsoft SQL Server Spatial Database</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class=""> XLS -vector- (ro): MS Excel format</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class=""> XLSX -vector- (rw+v): MS Office Open XML spreadsheet</span></div>
</div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class="">
</span></div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class=""><br class="">
</div>
<div class="">
<blockquote type="cite" class=""><br class="">
</blockquote>
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">On Feb 13, 2019, at 3:00 PM, <a href="mailto:gdal-dev-request@lists.osgeo.org" class="">
gdal-dev-request@lists.osgeo.org</a> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">Send gdal-dev mailing list submissions to<br class="">
<span class="Apple-tab-span" style="white-space:pre"></span><a href="mailto:gdal-dev@lists.osgeo.org" class="">gdal-dev@lists.osgeo.org</a><br class="">
<br class="">
To subscribe or unsubscribe via the World Wide Web, visit<br class="">
<span class="Apple-tab-span" style="white-space:pre"></span><a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" class="">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br class="">
or, via email, send a message with subject or body 'help' to<br class="">
<span class="Apple-tab-span" style="white-space:pre"></span>gdal-dev-request@lists.osgeo.org<br class="">
<br class="">
You can reach the person managing the list at<br class="">
<span class="Apple-tab-span" style="white-space:pre"></span>gdal-dev-owner@lists.osgeo.org<br class="">
<br class="">
When replying, please edit your Subject line so it is more specific<br class="">
than "Re: Contents of gdal-dev digest..."<br class="">
<br class="">
<br class="">
Today's Topics:<br class="">
<br class="">
1. Re: MSSQL Driver on Mac (Peter Petrik)<br class="">
2. Re: MSSQL Driver on Mac (Andreas Oxenstierna)<br class="">
<br class="">
<br class="">
----------------------------------------------------------------------<br class="">
<br class="">
Message: 1<br class="">
Date: Wed, 13 Feb 2019 15:26:06 +0100<br class="">
From: Peter Petrik <peter.petrik@lutraconsulting.co.uk><br class="">
To: "Horn, Ian I (COT)" <Ian.Horn@ky.gov><br class="">
Cc: "gdal-dev@lists.osgeo.org" <gdal-dev@lists.osgeo.org><br class="">
Subject: Re: [gdal-dev] MSSQL Driver on Mac<br class="">
Message-ID:<br class="">
<span class="Apple-tab-span" style="white-space:pre"></span><CA+T_MsJpeSiwaDwCtm3zqRnMt_8ftRO_KJ4urje0kgA0uw5nYw@mail.gmail.com><br class="">
Content-Type: text/plain; charset="utf-8"<br class="">
<br class="">
Hi, which installation do you use?<br class="">
<br class="">
Cheers,<br class="">
Peter<br class="">
<br class="">
On Wed, Feb 13, 2019 at 3:14 PM Horn, Ian I (COT) <Ian.Horn@ky.gov> wrote:<br class="">
<br class="">
<blockquote type="cite" class="">I am trying to access a SQL Server on QGIS, but I get the “error opening<br class="">
connection: Driver not loaded Driver not loaded”. QGIS installs GDAL<br class="">
2.3.2. On my PC I know how to get to the root folders and check to see if<br class="">
the driver is there but not on my Mac. If I use my terminal I get the<br class="">
following:<br class="">
<br class="">
Unable to open datasource<br class="">
`mssql:server=XXXXXXXXX;database=XXXX;tables=XXXXX.TrafficCameras;XXXXXX;<br class="">
' with the following drivers.<br class="">
<br class="">
How do I install or make this driver work on my Mac for both command line<br class="">
and use in QGIS?<br class="">
<br class="">
Thanks,<br class="">
<br class="">
Ian<br class="">
_______________________________________________<br class="">
gdal-dev mailing list<br class="">
gdal-dev@lists.osgeo.org<br class="">
https://lists.osgeo.org/mailman/listinfo/gdal-dev<br class="">
</blockquote>
-------------- next part --------------<br class="">
An HTML attachment was scrubbed...<br class="">
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/a0a61fdb/attachment-0001.html><br class="">
<br class="">
------------------------------<br class="">
<br class="">
Message: 2<br class="">
Date: Wed, 13 Feb 2019 15:27:54 +0100<br class="">
From: Andreas Oxenstierna <ao@t-kartor.se><br class="">
To: gdal-dev@lists.osgeo.org<br class="">
Subject: Re: [gdal-dev] MSSQL Driver on Mac<br class="">
Message-ID: <0a58531e-caab-7ce7-f0de-d1fd58917530@t-kartor.se><br class="">
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br class="">
<br class="">
What is ogrinfo reporting?<br class="">
ogrinfo --formats | grep MS<br class="">
<br class="">
For me (macOS 10.14.2 GDAL 2.3.2) it reports:<br class="">
MSSQLSpatial -vector- (rw+): Microsoft SQL Server Spatial Database<br class="">
<br class="">
<blockquote type="cite" class="">I am trying to access a SQL Server on QGIS, but I get the “error
<br class="">
opening connection: Driver not loaded Driver not loaded”. QGIS <br class="">
installs GDAL 2.3.2. On my PC I know how to get to the root folders <br class="">
and check to see if the driver is there but not on my Mac. If I use <br class="">
my terminal I get the following:<br class="">
<br class="">
Unable to open datasource <br class="">
`mssql:server=XXXXXXXXX;database=XXXX;tables=XXXXX.TrafficCameras;XXXXXX;<br class="">
' with the following drivers.<br class="">
<br class="">
How do I install or make this driver work on my Mac for both command <br class="">
line and use in QGIS?<br class="">
<br class="">
Thanks,<br class="">
<br class="">
Ian<br class="">
<br class="">
_______________________________________________<br class="">
gdal-dev mailing list<br class="">
gdal-dev@lists.osgeo.org<br class="">
https://lists.osgeo.org/mailman/listinfo/gdal-dev<br class="">
</blockquote>
<br class="">
<br class="">
-- <br class="">
Hälsningar<br class="">
<br class="">
Andreas Oxenstierna<br class="">
T-Kartor Geospatial AB<br class="">
Olof Mohlins väg 12 Kristianstad<br class="">
mobile: +46 733 206831<br class="">
mailto: ao@t-kartor.se<br class="">
http://www.t-kartor.com<br class="">
<br class="">
-------------- next part --------------<br class="">
An HTML attachment was scrubbed...<br class="">
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/0fbf5c3a/attachment-0001.html><br class="">
<br class="">
------------------------------<br class="">
<br class="">
Subject: Digest Footer<br class="">
<br class="">
_______________________________________________<br class="">
gdal-dev mailing list<br class="">
gdal-dev@lists.osgeo.org<br class="">
https://lists.osgeo.org/mailman/listinfo/gdal-dev<br class="">
<br class="">
------------------------------<br class="">
<br class="">
End of gdal-dev Digest, Vol 177, Issue 19<br class="">
*****************************************<br class="">
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
_______________________________________________<br class="">gdal-dev mailing list<br class=""><a href="mailto:gdal-dev@lists.osgeo.org" class="">gdal-dev@lists.osgeo.org</a><br class="">https://lists.osgeo.org/mailman/listinfo/gdal-dev</div></blockquote></div><br class=""><div class="">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div class=""><div class=""><div class="">-----</div><div class="">William Kyngesburye <kyngchaos*at*kyngchaos*dot*com></div><div class=""><a href="http://www.kyngchaos.com/" class="">http://www.kyngchaos.com/</a></div><div class=""><br class=""></div><div class="">The equator is so long, it could encircle the earth completely once.</div></div></div></span>
</div>
<br class=""></div></body></html>