https://issues.qgis.org/https://issues.qgis.org/favicon.ico2017-06-16T08:28:23ZQGIS Issue TrackingQGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=804322017-06-16T08:28:23ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>File</strong> <a href="/attachments/download/11077/Screenshot_20170616_092826.png">Screenshot_20170616_092826.png</a> added</li><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>invalid</i></li></ul><p>Use the native MSSQL provider that QGIS has. See attached image.</p> QGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=804332017-06-16T08:44:41ZJerome Anthonyjerome.pradeep+osgeo@gmail.com
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>Reopened</i></li></ul><p>Hi Giovannie,</p>
<p>I am still getting errors, and it's not very obvious on how to proceed further</p> QGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=804342017-06-16T08:45:44ZJerome Anthonyjerome.pradeep+osgeo@gmail.com
<ul><li><strong>File</strong> <a href="/attachments/download/11078/qgis-error-connect.jpeg">qgis-error-connect.jpeg</a> added</li></ul><p>Image attached</p> QGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=804352017-06-16T08:53:10ZJerome Anthonyjerome.pradeep+osgeo@gmail.com
<ul><li><strong>File</strong> <a href="/attachments/download/11079/qgis-mssql-gibberish.jpeg">qgis-mssql-gibberish.jpeg</a> added</li></ul><p>Attached the image with gibberish in error message</p> QGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=804362017-06-16T08:53:36ZJerome Anthonyjerome.pradeep+osgeo@gmail.com
<ul></ul><p>Giovanni Manghi wrote:</p>
<blockquote>
<p>Use the native MSSQL provider that QGIS has. See attached image.</p>
</blockquote>
<p>I am using this one</p> QGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=804382017-06-16T13:28:29ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Reopened</i> to <i>Closed</i></li></ul><p>Jerome Anthony wrote:</p>
<blockquote>
<p>Image attached</p>
</blockquote>
<p>in "host" use the IP address or host name of the server, you don't need to create a DSN with ODBC and use it. QGIS connects natively and directly to mssql server.</p> QGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=804392017-06-16T13:29:14ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Jerome Anthony wrote:</p>
<blockquote>
<p>Attached the image with gibberish in error message</p>
</blockquote>
<p>could you please try an see if it happens also on Windows or Linux?<br />in any case this would be a separate issue and needs a separate ticket.</p> QGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=804472017-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/16718">Bug report #16718</a>: QGIS MSSQL Layer creation error in OSX</i> added</li></ul> QGIS Application - Bug report #16716: QGIS MSSQL connection creation issuehttps://issues.qgis.org/issues/16716?journal_id=835202017-10-16T07:08:11ZMick Collopymick@audienceware.com
<ul></ul><p>I have no trouble connecting to MSSQL from Windows desktop but Linux (Ubuntu) desktop produces 'driver not laoded' error.<br />There's an issue for that <a class="issue tracker-1 status-5 priority-4 priority- closed" href="https://issues.qgis.org/issues/16718" title="QGIS MSSQL Layer creation error in OSX (Closed)">#16718</a></p>