QGIS » QGIS Application

Giovanni Manghi wrote:

is this to report the same kind of issue as #16716?

Is there anything you guys want from my side? This works fine on Windows.

Jerome Anthony wrote:

Giovanni Manghi wrote:

is this to report the same kind of issue as #16716?

Is there anything you guys want from my side? This works fine on Windows.

likely (not 100% sure) this means that some MS library is needed, and maybe this is only available for Windows and then only shipped with QGIS for Windows.

Interestngly enough GDAL/OGR has supports for MSSQL server, and this should also work out of the box on non Windows OSes, this is for example what my linux box says:

giovanni@sibirica:~$ ogrinfo --formats | grep SQL
SQLite vector- (rw+v): SQLite / Spatialite
MSSQLSpatial vector- (rw+): Microsoft SQL Server Spatial Database
PostgreSQL vector- (rw+): PostgreSQL/PostGIS
MySQL vector- (rw+): MySQL
PGDUMP vector- (w+v): PostgreSQL SQL dump

I have the same issue, as does a colleague, although I'm not sure if the cause is identical because it's a very general error message. I'm on MacOS 10.12.6.

In addition, on clicking 'List Databases' while attempting to add a MSSQL connection, I get the following error message:

[iODBC][Driver Manager]dlopen({FreeTDS}, 6): image not found [iODBC][Driver Manager]Specified driver could not be loaded QODBC3: Unable to connect

Driver not loaded Driver not loaded

There is some more information about this here https://github.com/Homebrew/legacy-homebrew/issues/24550. It appears that recent versions of OS X/MacOS do not come the necessary iODBC headers.

Any help on this would be greatly appreciated - I suspect the problem is common amongst Mac users however we probably do not often have a need to connect to MSSQL databases so it goes unreported.

Chid Gilovitz wrote:

I have the same issue, as does a colleague, although I'm not sure if the cause is identical because it's a very general error message. I'm on MacOS 10.12.6.

are you using the native MSSQL provider (layer > add layer > add MSSQL Spatial Layer)?

Giovanni Manghi wrote:

are you using the native MSSQL provider (layer > add layer > add MSSQL Spatial Layer)?

Apologies for not specifying. Yes.

I have no trouble at all from windows desktop - not it is on localhost, but evidently the native provider loads the driver.
However on Linux (Ubuntu) no matter what I try with ODBC, FfreeTDS, iODBC, although the server can connect, QGIS cannot load the driver.
Not sure whether the issue is the provider or the driver.

This post suggest may the linux distros are not compiled with the driver
http://osgeo-org.1560.x6.nabble.com/QGIS-MSSQL-2008-Data-import-problem-tp4986449p4987086.html
Is this the missing piece of the puzzle? Does this trigger something for someone else?

Mick Collopy wrote:

This post suggest may the linux distros are not compiled with the driver
http://osgeo-org.1560.x6.nabble.com/QGIS-MSSQL-2008-Data-import-problem-tp4986449p4987086.html
Is this the missing piece of the puzzle? Does this trigger something for someone else?

Did you install libqt4-sql-tds / libqt5sql5-tds (debian/ubuntu - might be called differently on your distribution)

Still getting the same issue after upgrading to 3.4
Yes, both libqt4-sql-tds / libqt5sql5-tds are installed.
All conncetion tests are successful from the command line to test
a) FreeTDS using tsql
b) ODBC using isql
Same error message "Error opening connection: Driver not loaded Driver not loaded"

What should be the settings for these?
Connection Name
Provider/DSN
Host

I found a workaround - I can import the data using add Vector layer, database
- finally got a query to work using FreeTDS on Linux, where the 'database' name had to be entered as the 'servername' in /etc/odbc.ini
- from there I can extract point data using Processing Toolbox, Qgis Geoalgorithms -> Vector Creation Tools ->points layer from table -> select x and y

However trying to use 'MSSQL Spatial Layer' still doesn't work, same error message 'driver not loaded'

Same issue here. Any news?