<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">We (so I do not remember the details)
managed to get it working circa 5 years ago using unixODBC.</div>
<div class="moz-cite-prefix">Since then, Microsoft have released an
official ODBC driver for macOS,
<a class="moz-txt-link-freetext" href="https://www.microsoft.com/en-us/download/details.aspx?id=56567">https://www.microsoft.com/en-us/download/details.aspx?id=56567</a></div>
<div class="moz-cite-prefix"><br>
</div>
<blockquote type="cite"
cite="mid:65732605-321A-4204-A1D0-BA12703E7BE9@kyngchaos.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
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=""
moz-do-not-send="true">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="" moz-do-not-send="true">
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="" moz-do-not-send="true">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=""
moz-do-not-send="true">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><a class="moz-txt-link-abbreviated" href="mailto:gdal-dev-request@lists.osgeo.org">gdal-dev-request@lists.osgeo.org</a><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><a class="moz-txt-link-abbreviated" href="mailto:gdal-dev-owner@lists.osgeo.org">gdal-dev-owner@lists.osgeo.org</a><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
<a class="moz-txt-link-rfc2396E" href="mailto:peter.petrik@lutraconsulting.co.uk"><peter.petrik@lutraconsulting.co.uk></a><br
class="">
To: "Horn, Ian I (COT)"
<a class="moz-txt-link-rfc2396E" href="mailto:Ian.Horn@ky.gov"><Ian.Horn@ky.gov></a><br class="">
Cc: <a class="moz-txt-link-rfc2396E" href="mailto:gdal-dev@lists.osgeo.org">"gdal-dev@lists.osgeo.org"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:gdal-dev@lists.osgeo.org"><gdal-dev@lists.osgeo.org></a><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><a class="moz-txt-link-rfc2396E" href="mailto:CA+T_MsJpeSiwaDwCtm3zqRnMt_8ftRO_KJ4urje0kgA0uw5nYw@mail.gmail.com"><CA+T_MsJpeSiwaDwCtm3zqRnMt_8ftRO_KJ4urje0kgA0uw5nYw@mail.gmail.com></a><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) <a class="moz-txt-link-rfc2396E" href="mailto:Ian.Horn@ky.gov"><Ian.Horn@ky.gov></a> 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="">
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br class="">
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br class="">
</blockquote>
-------------- next part --------------<br
class="">
An HTML attachment was scrubbed...<br
class="">
URL:
<a class="moz-txt-link-rfc2396E" href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/a0a61fdb/attachment-0001.html"><http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/a0a61fdb/attachment-0001.html></a><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
<a class="moz-txt-link-rfc2396E" href="mailto:ao@t-kartor.se"><ao@t-kartor.se></a><br class="">
To: <a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br class="">
Subject: Re: [gdal-dev] MSSQL Driver on Mac<br
class="">
Message-ID:
<a class="moz-txt-link-rfc2396E" href="mailto:0a58531e-caab-7ce7-f0de-d1fd58917530@t-kartor.se"><0a58531e-caab-7ce7-f0de-d1fd58917530@t-kartor.se></a><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="">
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br class="">
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><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: <a class="moz-txt-link-abbreviated" href="mailto:ao@t-kartor.se">ao@t-kartor.se</a><br class="">
<a class="moz-txt-link-freetext" href="http://www.t-kartor.com">http://www.t-kartor.com</a><br class="">
<br class="">
-------------- next part --------------<br
class="">
An HTML attachment was scrubbed...<br
class="">
URL:
<a class="moz-txt-link-rfc2396E" href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/0fbf5c3a/attachment-0001.html"><http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/0fbf5c3a/attachment-0001.html></a><br
class="">
<br class="">
------------------------------<br class="">
<br class="">
Subject: Digest Footer<br class="">
<br class="">
_______________________________________________<br class="">
gdal-dev mailing list<br class="">
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br class="">
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><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=""
moz-do-not-send="true">gdal-dev@lists.osgeo.org</a><br
class="">
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a></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="" moz-do-not-send="true">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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a></pre>
</blockquote>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Hälsningar
Andreas Oxenstierna
T-Kartor Geospatial AB
Olof Mohlins väg 12 Kristianstad
mobile: +46 733 206831
mailto: <a class="moz-txt-link-abbreviated" href="mailto:ao@t-kartor.se">ao@t-kartor.se</a>
<a class="moz-txt-link-freetext" href="http://www.t-kartor.com">http://www.t-kartor.com</a></pre>
</body>
</html>