<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">What is ogrinfo reporting?</div>
<div class="moz-cite-prefix">ogrinfo --formats | grep MS</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">For me (macOS 10.14.2 GDAL 2.3.2) it
reports:<br>
MSSQLSpatial -vector- (rw+): Microsoft SQL Server Spatial Database<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<blockquote type="cite"
cite="mid:93AC6EC0-F3C4-4E24-B204-06735A0C57A3@ky.gov">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
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:
<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="">Unable to open datasource
`mssql:server=XXXXXXXXX;database=XXXX;tables=XXXXX.TrafficCameras;XXXXXX;</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="">' with the following drivers.</span></div>
</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=""><br class="">
</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px;
line-height: normal; font-family: Menlo;" class="">
How do I install or make this driver work on my Mac for both
command line and use in QGIS?</div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px;
line-height: normal; font-family: Menlo;" class="">
<br class="">
</div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px;
line-height: normal; font-family: Menlo;" class="">
Thanks,</div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px;
line-height: normal; font-family: Menlo;" class="">
<br class="">
</div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px;
line-height: normal; font-family: Menlo;" class="">
Ian</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>