<div dir="auto">Francesco and list,<div dir="auto"><br></div><div dir="auto">Please look at this <a href="http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-MSSQL-driver-not-found-amp-Can-t-open-lib-SQL-Server-QGIS-2-18-LTR-on-Debian-td5386050.html">http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-MSSQL-driver-not-found-amp-Can-t-open-lib-SQL-Server-QGIS-2-18-LTR-on-Debian-td5386050.html</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jul 3, 2020, 01:16 Francesco D Alesio <<a href="mailto:francesco.dalesio@ies.it">francesco.dalesio@ies.it</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>

  
  
  

<div>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">Hello everybody,</span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">I'm trying to display an MS Sql Server layer with QGIS Server (3.12) installed on a Debian 10 machine.</span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><br></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">The project is giving the "Layer(s) not valid" error, because of the MS Sql Server layer (postgis layers are working properly).</span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><br></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">I've installed the odbc driver, and now I can connect to sql server with ogr2ogr, specifyng "Driver={ODBC Driver 17 for SQL Server}" in the connection string.</span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">Than I added a [SQL Server] section to /etc/odbcinst.ini , and now ogr2ogr works without the Driver in the connection string.</span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">But QGIS is still giving the <span style="font-size:13.3333px">"</span><span style="font-size:13.3333px">Layer(s) not valid" error.</span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px"><br></span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px">I've also tried to add the driver name to the source attribute of the layer-tree-layer element of the qgs file, without success.</span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px"><br></span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">Three questions:</span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">1. What else can I try?</span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif">2. <span style="font-size:13.3333px">Is there a way to get more detailed error information? apache error logs are empty, and </span><span style="font-size:13.3333px">QGIS_SERVER_LOG_FILE contains just the layer id (</span><span style="font-size:13.3333px">QGIS_SERVER_LOG_LEVEL=0 and </span><span style="font-size:13.3333px">QGIS_DEBUG=9)</span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px">3. Do you recommend using windows instead of debian in this environment?</span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px"><br></span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px">Thank you</span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px"><br></span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px">Regards</span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px"><br></span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px"><br></span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px">Francesco</span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px"><br></span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><span style="font-size:13.3333px"><br></span></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><br></span></p>
<p style="padding:0;margin:0"><span style="font-size:10pt;font-family:tahoma,arial,helvetica,sans-serif"><br></span></p>

</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" rel="noreferrer">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote></div>