<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body 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><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>https://lists.osgeo.org/mailman/listinfo/gdal-dev<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>
</body>
</html>