[gdal-dev] MSSQL Driver on Mac (Andreas Oxenstierna)

[Horn, Ian I (COT)]

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-request at lists.osgeo.org<mailto:gdal-dev-request at lists.osgeo.org> wrote:

Send gdal-dev mailing list submissions to
gdal-dev at lists.osgeo.org<mailto:gdal-dev at 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-request at lists.osgeo.org

You can reach the person managing the list at
gdal-dev-owner at 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.petrik at lutraconsulting.co.uk>
To: "Horn, Ian I (COT)" <Ian.Horn at ky.gov>
Cc: "gdal-dev at lists.osgeo.org" <gdal-dev at lists.osgeo.org>
Subject: Re: [gdal-dev] MSSQL Driver on Mac
Message-ID:
<CA+T_MsJpeSiwaDwCtm3zqRnMt_8ftRO_KJ4urje0kgA0uw5nYw at 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.Horn at 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 at 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 <ao at t-kartor.se>
To: gdal-dev at lists.osgeo.org
Subject: Re: [gdal-dev] MSSQL Driver on Mac
Message-ID: <0a58531e-caab-7ce7-f0de-d1fd58917530 at 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 at 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: ao at 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 at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

------------------------------

End of gdal-dev Digest, Vol 177, Issue 19
*****************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20190213/73a4cab4/attachment.html>