[Qgis-user] R: QGIS Server on Debian - MSSqlServer layer

[Francesco D Alesio]

Chris,

thank you for the answer.


Unfortunately, while ogr2ogr is working properly following those suggestions, qgis is not.





Francesco





-----Messaggio originale-----
Da: chris hermansen <clhermansen at gmail.com>
Inviato: Venerdì 3 Luglio 2020 16:25
A: Francesco D Alesio <francesco.dalesio at ies.it>
Cc: qgis-user <qgis-user at lists.osgeo.org>
Oggetto: Re: [Qgis-user] QGIS Server on Debian - MSSqlServer layer

Francesco and list,

Please look at this 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

On Fri, Jul 3, 2020, 01:16 Francesco D Alesio <francesco.dalesio at ies.it <mailto:francesco.dalesio at ies.it> > wrote:
Hello everybody,

I'm trying to display an MS Sql Server layer with QGIS Server (3.12) installed on a Debian 10 machine.



The project is giving the "Layer(s) not valid" error, because of the MS Sql Server layer (postgis layers are working properly).



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.

Than I added a [SQL Server] section to /etc/odbcinst.ini , and now ogr2ogr works without the Driver in the connection string.

But QGIS is still giving the "Layer(s) not valid" error.



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.



Three questions:

1. What else can I try?

2. Is there a way to get more detailed error information? apache error logs are empty, and QGIS_SERVER_LOG_FILE contains just the layer id (QGIS_SERVER_LOG_LEVEL=0 and QGIS_DEBUG=9)

3. Do you recommend using windows instead of debian in this environment?



Thank you



Regards





Francesco









_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org> 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200703/fedb1950/attachment.html>