https://issues.qgis.org/https://issues.qgis.org/favicon.ico2017-06-18T21:18:54ZQGIS Issue TrackingQGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=804422017-06-18T21:18:54ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>is this to report the same kind of issue as <a class="issue tracker-1 status-5 priority-4 priority- closed" href="https://issues.qgis.org/issues/16716" title="QGIS MSSQL connection creation issue (Closed)">#16716</a>?</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=804462017-06-19T06:56:12ZJürgen Fischerjef@norbit.de
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority- closed" href="/issues/16716">Bug report #16716</a>: QGIS MSSQL connection creation issue</i> added</li></ul> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=804622017-06-20T06:36:45ZJerome Anthonyjerome.pradeep+osgeo@gmail.com
<ul></ul><p>Giovanni Manghi wrote:</p>
<blockquote>
<p>is this to report the same kind of issue as <a class="issue tracker-1 status-5 priority-4 priority- closed" href="https://issues.qgis.org/issues/16716" title="QGIS MSSQL connection creation issue (Closed)">#16716</a>?</p>
</blockquote>
<p>Is there anything you guys want from my side? This works fine on Windows.</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=804672017-06-20T12:21:16ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Jerome Anthony wrote:</p>
<blockquote>
<p>Giovanni Manghi wrote:</p>
<blockquote>
<p>is this to report the same kind of issue as <a class="issue tracker-1 status-5 priority-4 priority- closed" href="https://issues.qgis.org/issues/16716" title="QGIS MSSQL connection creation issue (Closed)">#16716</a>?</p>
</blockquote>
<p>Is there anything you guys want from my side? This works fine on Windows.</p>
</blockquote>
<p>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.</p>
<p>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:</p>
<p>giovanni@sibirica:~$ ogrinfo --formats | grep SQL<br /> SQLite vector- (rw+v): SQLite / Spatialite<br /> <strong>MSSQLSpatial vector- (rw+): Microsoft SQL Server Spatial Database</strong><br /> PostgreSQL vector- (rw+): PostgreSQL/PostGIS<br /> MySQL vector- (rw+): MySQL<br /> PGDUMP vector- (w+v): PostgreSQL SQL dump</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=819722017-09-08T07:56:16ZChid Gilovitzchid.gilovitz@gmail.com
<ul></ul><p>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.</p>
<p>In addition, on clicking 'List Databases' while attempting to add a MSSQL connection, I get the following error message: <br /><pre>
[iODBC][Driver Manager]dlopen({FreeTDS}, 6): image not found [iODBC][Driver Manager]Specified driver could not be loaded QODBC3: Unable to connect
</pre><br />It's interesting that 'List Databases' gives a different error message to 'Test Connection', which just says <pre>Driver not loaded Driver not loaded</pre>.<br />Following this up on the iODBC site (<a class="external" href="http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/FAQ#%5BiODBC%5D%20%5BDriver%20Manager%5DSpecified%20driver%20could%20not%20be%20loaded">http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/FAQ#%5BiODBC%5D%20%5BDriver%20Manager%5DSpecified%20driver%20could%20not%20be%20loaded</a>) suggests that iODBC cannot find the .so file needed for the driver. I have attempted to fix this problem by reinstalling FreeTDS and ensuring the driver file is where it should be and there is an odbcinst.ini file that points to it. This didn't work.</p>
<p>There is some more information about this here <a class="external" href="https://github.com/Homebrew/legacy-homebrew/issues/24550">https://github.com/Homebrew/legacy-homebrew/issues/24550</a>. It appears that recent versions of OS X/MacOS do not come the necessary iODBC headers.</p>
<p>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.</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=819782017-09-08T09:05:59ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Chid Gilovitz wrote:</p>
<blockquote>
<p>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.</p>
</blockquote>
<p>are you using the native MSSQL provider (layer > add layer > add MSSQL Spatial Layer)?</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=820732017-09-10T13:11:56ZChid Gilovitzchid.gilovitz@gmail.com
<ul></ul><p>Giovanni Manghi wrote:</p>
<blockquote>
<p>are you using the native MSSQL provider (layer > add layer > add MSSQL Spatial Layer)?</p>
</blockquote>
<p>Apologies for not specifying. Yes.</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=820792017-09-11T10:56:52ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li></ul> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=835212017-10-16T07:14:18ZMick Collopymick@audienceware.com
<ul></ul><p>I have no trouble at all from windows desktop - not it is on localhost, but evidently the native provider loads the driver.<br />However on Linux (Ubuntu) no matter what I try with ODBC, FfreeTDS, iODBC, although the server can connect, QGIS cannot load the driver.<br />Not sure whether the issue is the provider or the driver.</p>
<p>This post suggest may the linux distros are not compiled with the driver<br /><a class="external" href="http://osgeo-org.1560.x6.nabble.com/QGIS-MSSQL-2008-Data-import-problem-tp4986449p4987086.html">http://osgeo-org.1560.x6.nabble.com/QGIS-MSSQL-2008-Data-import-problem-tp4986449p4987086.html</a><br />Is this the missing piece of the puzzle? Does this trigger something for someone else?</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=835362017-10-16T10:34:26ZJürgen Fischerjef@norbit.de
<ul></ul><p>Mick Collopy wrote:</p>
<blockquote>
<p>This post suggest may the linux distros are not compiled with the driver<br /><a class="external" href="http://osgeo-org.1560.x6.nabble.com/QGIS-MSSQL-2008-Data-import-problem-tp4986449p4987086.html">http://osgeo-org.1560.x6.nabble.com/QGIS-MSSQL-2008-Data-import-problem-tp4986449p4987086.html</a><br />Is this the missing piece of the puzzle? Does this trigger something for someone else?</p>
</blockquote>
<p>Did you install libqt4-sql-tds / libqt5sql5-tds (debian/ubuntu - might be called differently on your distribution)</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=835402017-10-16T10:36:38ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=916482018-08-15T17:33:44ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>not reproducable</i></li></ul><p>Closing for lack of feedback.</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=978142019-01-05T07:03:33ZMick Collopymick@audienceware.com
<ul></ul><p>Still getting the same issue after upgrading to 3.4<br />Yes, both libqt4-sql-tds / libqt5sql5-tds are installed.<br />All conncetion tests are successful from the command line to test <br />a) FreeTDS using tsql<br />b) ODBC using isql<br />Same error message "Error opening connection: Driver not loaded Driver not loaded"</p>
<p>What should be the settings for these?<br />Connection Name<br />Provider/DSN<br />Host</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=978332019-01-06T20:36:32ZMick Collopymick@audienceware.com
<ul></ul><p>I found a workaround - I can import the data using add Vector layer, database<br />- 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<br />- from there I can extract point data using Processing Toolbox, Qgis Geoalgorithms -> Vector Creation Tools ->points layer from table -> select x and y</p>
<p>However trying to use 'MSSQL Spatial Layer' still doesn't work, same error message 'driver not loaded'</p> QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSXhttps://issues.qgis.org/issues/16718?journal_id=1002142019-02-16T09:44:29ZNikolay Lebedevnextstopsun@gmail.com
<ul></ul><p>Same issue here. Any news?</p>